Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: JBaileys
  • Content: Threads
  • Order by date
  1. JBaileys

    Calling a query with a user define function UDF

    Within a function, a query is built which can be quite complex. The query is a varchar which is manipulated by the function. What is the syntax to execute the query? The result set is functions return (returns a table). Thanks, JB
  2. JBaileys

    SQL0433N Value is too long - user defined function

    I have a function that has a varchar about 300 characters. When I run the insert command from a function I receive the error SQL0433N - Value .... is too long SQLSTATE=22001. If I run the query outside of the function it seems to work fine. I read about char limitations of 255 characters...
  3. JBaileys

    Batch file sequential limitation

    With a batch file, the first command executes and finishes prior to the second command starting. Is there a way to run all the statements at once like & in a shell script?
  4. JBaileys

    Escape key ie \

    On a closed thread Ken suggested escaping the " (ie \)" What does this mean - are there any good references to escape keys? ==== Highlights from closed message ============= KenCunningham Have you tried escaping the " (ie \")? Perhaps a simple one, but I could do with a pointer here. I...
  5. JBaileys

    Process Id for roll forward

    How would you get the process id for a roll forward command? Only looking for the PID. ps -r | grep -i ?rollforward? If I use ps -r pid, it only returns the number but I have no way to know that i came from a roll forward command.
  6. JBaileys

    Script to run for 3 hours

    Is there a way to look to see if a process is running for more than 3 hours. If it is running more than 3 hours, it should echo a simple failure message. #identify process to kill STARTDATE=`date -d +%s` # Timelimit in seconds TIMELIMIT = 10800 CDATE=`date -d +%s` DIFF = CDATE - STARTDATE...
  7. JBaileys

    declare a function within a stored procedure

    I am looking to declare a function with a stored procedure. The goal is to call the function within the stored procedure.
  8. JBaileys

    MQT optimization

    When using a base underlining table to query data that is already calculated in the MQT table, I assume the system would pull from the MQT table. What conditions "encourage" the system to pull from the MQT table rather than the underlining base tables.
  9. JBaileys

    MQT create issue

    trying to create a MQT and it fails with error: During SQL processing it returned: SQL0206N "f" is not valid in the context where it is used. SQLSTATE=42703 create table user.ytable as (select PERIOD, a, b, c, D, e sum(f) as sum_f, min (f) as min_f, g from USER.yraw group by grouping...
  10. JBaileys

    DBMS connection

    Using ERWin to connect to DB2. What is the DBMS connection string? Are there defaults?
  11. JBaileys

    Open dialog in MS Access is slow

    Looking to export a table and finding the destination db is very slow as opening the folders within the export dialog is so slow. Thanks, -JB
  12. JBaileys

    Exporting data between db files - open dialog is slow

    I am exporting a table from db1 to db2 and the dialog titled: "Export table to..." is extremely slow. I am running only on my local drive which is relatively quick. -JB
  13. JBaileys

    Updating datetime field

    Is there a way to update the date field, but keep the time field in tact. Update table set [SurpriseDate] = datepart(mm,...) Thanks, jb
  14. JBaileys

    Display data from multiple tables

    In the current schema, there is one master table with a colors sub-table and location sub table. Master has a 1 to many relationship with both colors and location. There may be merit in creating two separate sql statements in what may be a subreport. The goal is to display the master item...
  15. JBaileys

    Listview control - display param name

    I am supporting an old ASP app that uses the MS Listview control (mscomctl.ocx). In the asp code, I notice there are param name such as multiselect, labelwrap, etc. that set the properties for the control. Is there any reference or support for unicode? Specifically the display of Japanese or...
  16. JBaileys

    NTLDR error - too many files root directory

    Installing our software - caused several temp files to be dumped into the root of the hard drive. This then causes an NTLDR error as there are too many files. What is the best way to be able to access the local drive to delete the files. I have used bootdisk which does not give me access.
  17. JBaileys

    New install: Data source name not found and no default driver ...

    Received error in the log: Data source name not found and no default driver specified This occurred when installing the developer edition of SQL Server. The machine is setup with Japanese regional settings and previously had an instance of MSDE before. MSDE has been removed and nothing...
  18. JBaileys

    Newbie ? about - mount

    I am very new to linux. I am able to mount a hard drive with the GUI. But, it is read-only. How can I mount the drive for read write... mount /mnt/hda2 -rw ?? Thanks, JB
  19. JBaileys

    Bit conversion

    We have a goofy implementation of a multiple join. Table Customers has a bits field that contains a relationship to associations. A customer can have 0, 1 or many associates. The poor implementation has a customer.associationid = 16 which represents the record with id = 5. 16 (dec) = 10000...
  20. JBaileys

    Kill all processes, Uninstall MSDE

    We have identified an issue when uninstalling MSDE and an active process to the db exists, it creates an awkward state of the db. We would like to kill all processes, stop the sql services and uninstall. Are there cmd line commands to get this done? Thanks, JB

Part and Inventory Search

Back
Top