Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

SQLCODE -204 in FOCUS

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics
View previous topic :: :: View next topic  
Author Message
geet16

New User


Joined: 22 Dec 2006
Posts: 24
Location: USA

PostPosted: Wed Feb 13, 2008 5:40 pm    Post subject: SQLCODE -204 in FOCUS
Reply with quote

Hi,

Using FOCUS we are generating a report. Here, we are first creating a Flat File using COBOL program and then using this flat file generating the report.

In Focus, we are creating a HOLD File in DB2 Format. Next we using this file we create another HOLD file when we get the following error
(FOC1400) SQLCODE IS -204 (HEX: FFFFFF34) XOPEN: 42S02
(FOC1409) SQL TABLE NOT FOUND. (FOR TABLE: CHECK SEGNAME AND TABLE)
(FOC1414) EXECUTE IMMEDIATE ERROR.

We have faced similar kind of problem last year; wherein we had reloaded the tables and recreated the indexes. This time even after doing this we are getting the same error.

Kindly let me know if anyone has ever faced this error and what more can be done to solve the same.

TIA.

Regards,
Geet
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed Feb 13, 2008 9:55 pm    Post subject:
Reply with quote

Hello,

It appears that your process has named an object that does not exist.

If you believe the problem object does exist, i'd suggest you open an issue with IBI support.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> All Other Mainframe Topics All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Relatated to FOCUS program Sumeendar All Other Mainframe Topics 1 Thu Mar 10, 2016 5:21 pm
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts FOCUS Database query lanand1985 All Other Mainframe Topics 4 Fri Jan 16, 2015 2:15 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us