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!
-
unpack unsigned packed field in db2
Hello I have to re-state this situation, it involves an unsigned packed decimal number. These numbers can/are created in assembler. Is there a way, if anyone knows, for DB2 to unpack this type of numeric field? Does the new UNPACK function do this? I would like to do this without arithmetic... -
unpack unsigned packed field in db2
An assembler program creates a file with unsigned packed numbers which is then uploaded to DB2 as as an A/N field. For example an account number will be represented as X'3899'. I want to unpack the field to '3899'. -
unpack unsigned packed field in db2
Does any know if there is a way to unpack an unsigned column to an A/N field in DB2? -
I am attempting to create a global
Hello all Finally, I have an answer to the questionI posed. This is a mainframe COBOL DGTT pgm that I was attenpting. Apparently, I needed to adD the keyword SESSION. to the DGTT. wherever it is refrenced (declare, cursor, insert etc). the pgm compiled and ran. -
I am attempting to create a global
Thank you all. I did make make some changes but encountered a new problem as follows: EXEC SQL DECLARE CURSOR1 CURSOR FOR SELECT * FROM TEMP_MAC END-EXEC EXEC SQL DECLARE... -
I am attempting to create a global
I am attempting to create a global temporary table in a COBOL program. I am getting the followoing messages: DSNH029I E DSNHAPL2 LINE 795 COL 15 "INTO" CLAUSE REQUIRED DSNH050I I DSNHMAIN WARNINGS HAVE BEEN SUPPRESSED DUE TO LACK OF TABLE DECL the following are the...
