 |
MVSFORUMS.com A Community of and for MVS Professionals
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
| Search found 4 matches |
| Author | Message |
|---|---|
 Topic: Embedding DECLARE GLOBAL TEMPORARY TABLE in COBOL |
|
| Susila Replies: 8 Views: 7391 |
 Forum: Database Posted: Wed May 12, 2004 6:10 am Subject: Embedding DECLARE GLOBAL TEMPORARY TABLE in COBOL |
| Hi,
Ya I am getting the compilation error. I checked out my SQL statements it starts after 12th column only. Susila. |
|
| Topic: Embedding DECLARE GLOBAL TEMPORARY TABLE in COBOL |
|
| Susila Replies: 8 Views: 7391 |
Forum: Database Posted: Wed May 12, 2004 4:46 am Subject: Embedding DECLARE GLOBAL TEMPORARY TABLE in COBOL |
| DSNH204I W DSNHANAL LINE 350 COL 17 STATEMENT REFERENCES UNDECLARED TABLE "SESSION"."RELATED_PROGRAMS"
INSERT INTO SESSION.RELATED_PROGRAMS SELECT DISTINCT 0,P.ENT_ID,1 FROM DBXIMS.DBX_IMS_PROGR ... |
|
| Topic: Embedding DECLARE GLOBAL TEMPORARY TABLE in COBOL |
|
| Susila Replies: 8 Views: 7391 |
Forum: Database Posted: Wed May 12, 2004 1:02 am Subject: Embedding DECLARE GLOBAL TEMPORARY TABLE in COBOL |
| There a mistake in the SQL.PLease find the correct SQL below.
EXEC SQL DECLARE GLOBAL TEMPORARY TABLE RELATED_PROGRAMS (SOURCE_ID INTEGER, TARGET_ID INTEGER, ROUND SMALLINT) ON COMMIT PRESERVE ... |
|
| Topic: Embedding DECLARE GLOBAL TEMPORARY TABLE in COBOL |
|
| Susila Replies: 8 Views: 7391 |
Forum: Database Posted: Tue May 11, 2004 11:40 pm Subject: Embedding DECLARE GLOBAL TEMPORARY TABLE in COBOL |
| Hi,
I am trying to embed a query which uses DECLARE GLOBAL TEMPORARY TABLE in COBOL but I am getting the following error message STATEMENT REFERENCES UNDECLARED TABLE "RELATED_PROGRAMS" My query ... |
|
All times are GMT - 5 Hours |