SELECT DAYS(CURRENT DATE) - DAYS(:WS-DT-RCVD) INTO :WS-TEMP-DAYS FROM VSREGS (vsregs is our 'nothing' table)And, I am getting the message in the precompile DSNH312I UNDEFINED OR UNUSABLE HOST VARIABLE "WS-TEMP-DAYS." WS-TEMP-DAYS is defined as PIC 9(8) in COBOL. I have also tried PIC 9(8) COMP-2, PIC 9(8) COMP-3 WS-DT-RCVD is defined as PIC X(10) and has the CCYY-MM-DD format date in it. So my question is, what is decimal 8 in COBOL?
Editor's note: Do you agree with this expert's response? If you have more to share, post it in one of our .VO7aaqqaAFk.0@/search390>discussion forums.
Dig Deeper on IBM DB2 management
Related Q&A from Craig S. Mullins
Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ... Continue Reading
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ... Continue Reading
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.