Search results for query: *

Faccorp, Do you think you have a lack of trust? I know the feeling. One recommendation is to have multiple people that can support the "maintenance" - just in case you go off to a new job. JB

DJ, Your company may consider bringing in a consultant or contractor for a short stint to help you through the process. Also, I am a firm believer that any application / system should be well known my at least 2 people. Therefore, if someone leaves or "gets hit by truck", then there is a...

I have tried multiple attempts. In one attempt, I do call a stored procedure and received an error SQL0746N routine ... violated nested sql statement rules when attempting to perform operation "modify" on table ... sqlstate = 57053

I think you may have to populate the "timestamp" your self. Will every imported record write to 100 tables? Or would a certain type of record write to a few tables and another type of record write to another set of tables. Not sure if this will help you. From BOL: @@DBTS Returns the value of...

Seems unusual that the C++ app creates the db. But, I don't want to question your approach - but you may want to think about it. You said: The bottom line is that I want each user to have the following rights: sp execute, create and alter views, and backup database. So, can I assume you...

Have you tried to compare it with left (variable, 5)?

I have not seen that error. When do you receive it, when db2 starts?

The issue is that that value was casted with char(). Therefore the limitation is about 256 characters. Removed char limitation and - it is corrected.

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

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...

A very interesting approach... Not sure why you would want to use the reverse function to reverse the string. If I understand your request, you want to take "Freak, Seuss D. 1234567489" and return 1234567489 Have you tried CAST ( em_id AS int ) ?

Actually I found an answer. It is "Start". If you prefix the statements with start, it will initate all the statements. Therefore, the script does not have to wait for statement one to finish to begin statement #2. Simplified Example: start copy log.txt log.bak start db2 -tvf create.sql The...

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?

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...

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.

The 3 hours is elapsed time (not cpu time). Thanks, jb

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...

This was a problem with a set up program that failed. No one took the software seriously. I am so happy I no longer work there. The grass is definitely greener on the other side.

DB2 runs on red hat linux. The function would be part of the stored procedure. The stored procedure is not calling something outside of itself. The function or subroutine would be internal to the sp. Not sure if I am answering your question.

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