MVSFORUMS.com

The first character of a DB2 table varchar column can be a special character/Numeric/Alphabet. How can I perform an ORDER BY so that the result contains all special characters first, then numeric and ...

I would like make one correction of my last post

I am getting a SQLCODE = -204 for 'testcol'.
When I have a.Col2 and/or a.Col5 the SQL runs fine, but it is only for 'testcol' because it is like ...

Thanks Kolusu for your suggestion of LOCATE. It worked, when I use it on one column. However, I did not try yet for more than one column.
For now, my secondary sort columns are defined, therefore LO ...

Thank you for all your inputs.

I am still looking at the static and dynamic SQL options, since it will be something new to my application and response times are also of a great concern.

Howeve ...

I have a requirement where I need to use multiple cursors in a DB2 stored procedure because of the different sort orders columns on the front end.

The numbers of cursors to be defined can go upto ...

I totally agree with jsharon1248 and dbz. Infact all the options available were reviewed and yes between random number and identity, identity key would be the best solution. But unfortunately, using i ...

why the random number?

For whatever reason this table was designed to have the random number. Only now seeing the issue with this and trying to find easy and simple ways to fix this issue. (Ge ...

After a lot of research, found that there is a issue with the way the random number is generated. The current module that generates the random number is based on current timestamp and since the ID num ...

Kolusu,

I have the results of the explain plan from production. I personally did not run any explains in test region yet. From my understanding about the explain plan table, I could not see anythi ...

In general the batch program takes a long time to run. Average run time is over an 1 hr. I am looking to optimize this run time as we may have a much higher volume going forward.

How much data is ...

I have a batch cobol program which performs slowly, current information about the program is as follows:
Performs Multi row insert (100 rows at a time)
inserts into two tables a parent and child tab ...

Finally it worked, the issue was with picking the program from the correct library. I had a incorrect library in the Endevor listing.

Thanks for all your help.

Actually this is an existing program and it has been running fine in Production. I modified this program with simple coding changes.

Also, I do have a SYSPRINT and even that is not appearing in t ...

This is a batch program.

Yes I do have //SYSOUT DD SYSOUT=*

Infact I tried both the above SYSOUT and also pointed to a dataset. When I point to the dataset, the dataset gets created but it is ...

When I execute/run a COBOL+IMS+DB2 program, I am missing the SYSOUT from the Job Log. In SDSF the JESMSGLG, JESJCL, JESYSMSG DD names appear but the SYSOUT DDNAME does not appear.

I have the displ ...