-927 sqlcode

venu_dr · New User Joined: 06 Jul 2006 Posts: 6

Hi,

I am getting the -927 sqlcode for the below sql statement. Can anybody help me to resolve this problem.

01 WS-DB2-TIMESTAMP PIC X(26) VALUE SPACES.

EXEC SQL
SET :WS-DB2-TIMESTAMP = CURRENT TIMESTAMP
END-EXEC

Thanks
Venu

Srihari Gonugunta · Posted: Fri Dec 07, 2007 12:52 pm

Hi Venu,
Use NODYNAM option in compilation, if you are currently using DYNAM.

venu_dr · New User Joined: 06 Jul 2006 Posts: 6

Hi

Thanks for u r reply.

I am getting the same SQLCODE after compiling the program with NODYNAM option.

dbzTHEdinosauer · Posted: Fri Dec 07, 2007 3:00 pm

Look up the -927 sqlcode explanation. you will find that it has nothing to do with your sql.

Krishnadeva Reddy · New User Joined: 14 Nov 2007 Posts: 37 Location: Chennai

Hi,

When I see your SQL I guess you want CURRENT TIMESTAMP should be moved to your working storage variable or host variable.Am I right?

If so then try this way,

You get the CURRENT TIMESTAMP into host variable.

EXEC SQL
SELECT CURRENT TIMESTAMP
INTO :WS-DB2-TIMESTAMP
FROM SYSIBM.SYSDUMMY.
END-EXEC

Craq Giegerich · Posted: Sat Dec 08, 2007 12:30 am

anv2005 · New User Joined: 14 Jul 2005 Posts: 44 Location: US

Craq is right.

Check your link edit listing and run-time JCL.

Make sure you use the correct DB2 attachment stub.

frudo · New User Joined: 16 Aug 2005 Posts: 5

Is your program a pure Db2 program or is it an IMS-DB2 program. If it has IMS then you will need to include the linkage control card in your development package.