DSNREXX: -104 in "DECLARE GLOBAL TEMPORARY TABLE "

pankajsoni · New User Joined: 21 Jun 2006 Posts: 9 Location: Zurich

Hi all,

I am trying to declare a global temporary table in one of my rexx exec. I am using DSNREXX.

However, I am getting -104.
Is it allowed to declare a global temporary table in rexx exec with DSNREXX ?

William Thompson · Posted: Tue Jul 17, 2007 4:08 pm

What does the -104 have to do with

pankajsoni · New User Joined: 21 Jun 2006 Posts: 9 Location: Zurich

While executing the below SQL(in rexx exec via DSNREXX) I am getting this sqlcode:

DECLARE GLOBAL TEMPORARY TABLE CRE.TEMP1
( NAME CHAR(8) NOT NULL,
TYPE CHAR(3) NOT NULL
)

SQLERRMC points to GLOBAL.

So my question is that : is it a valid statement in rexx or not ?

William Thompson · Posted: Tue Jul 17, 2007 4:26 pm

pankajsoni · New User Joined: 21 Jun 2006 Posts: 9 Location: Zurich

Let me rephrase it again,

Rexx does support embedded SQL statements. I am doing all other types of sql operations, like SELECT, INSERT, UPDATE, DELETE, DECLARE CURSOR etc, without any problem...

But, when I am trying to execute above query (DECLARE GLOBAL TEMPORARY TABLE) it get fail with a SQLCODE of -104.
I know this is an error because of some token mismatch. But as the syntax is correct and I am unable to find out the error. So, I have the doubt that whether DSNREXX support DECLARE GLOBAL TEMPORARY TABLE or not ???

William Thompson · Posted: Tue Jul 17, 2007 4:47 pm

I have no clue if DSNREXX supports DECLARE GLOBAL TEMPORARY TABLE or not, but the fact that you are getting a DB2 error, would have me leaning towards the fact that it can....

dbzTHEdinosauer · Posted: Fri Aug 03, 2007 8:56 pm

according to REXX Language Support Version 5: