Привет господа. Предлагаем Вашему вниманию изделия из стекла для дома и офиса.Наша организация ООО «СТЕКЛОЭЛИТ» работает 10 ..read more

The SQLCA field descriptions are here: https://www.ibm.com/docs/en/db2-for-zos ... ion-fields The most useful (and most commonly used) thing in there is the SQLCODE. Over the years, I've found it's fairly rare to find an embedded SQL program which uses pretty much any of the other fields particularly as some of them are very conditional and the values can be difficult to interpret programatically. It's why DSNTIAR is an ideal solution to the error reporting problem. Not only is it DB2's own error reporting module, but you'll get a full error message and dump of the relevant SQLCA fields. Stat ..read more

Thanks zum13, this is really helpful. Is there a document which can help me to learn more about SQLCA? Statistics: Posted by Ramesh_Mainframe — Thu Apr 25, 2024 5:11 am ..read more

You should be looking at what program is executed by the JCL, you are referring to. Statistics: Posted by Anuj Dhawan — Wed Apr 24, 2024 9:12 am ..read more

Can I contact Administration? It is important. Regards. Statistics: Posted by Michailfpv — Wed Apr 24, 2024 6:55 am ..read more

Can I contact Administration? It is important. Thank. Statistics: Posted by Michailfpv — Wed Apr 24, 2024 6:54 am ..read more

Hi, Does any one have idea about rc 1000 in JCL?   Statistics: Posted by Anushka Sharma — Wed Apr 24, 2024 6:39 am ..read more

Yes. COBOL does not handle character data in the same way as something like C where there is a string termination character (the null). If you do Code: MOVE 'A' TO WA-FIELD-1 and WA-FIELD-1 is 40 characters, COBOL will move the 'A' followed by 39 spaces. You have to rely on other means to determine that there's only one non-space character in the field. The statement you're probably better off using is INSPECT which has TALLYING options for calculating the lengths of things. There's also the "REVERSE" function which will reverse the characters in a field (don't overwrite the original!) whi ..read more

Hello. The available information about any SQL errors you encounter should be within the SQLCA (the SQL Communication Area). The subject of error handling has come up before and my general recommendation would be to use the DB2's error handling module DSNTIAR to help with message reporting. There's more information in this thread that should be of help: https://zmainframes.com/viewtopic.php?p ... iar#p34662 Statistics: Posted by zum13 — Wed Apr 24, 2024 12:40 am ..read more

Directory4U Click here! Statistics: Posted by Stevenlax — Wed Apr 24, 2024 12:08 am ..read more