Recent content by JBaileys

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.