What is SQL Code -904 and -903 in DB2 And how to handle it?

Answer Posted / ajay digule

Yes unsuccessful execution of a DB2 query due to an unavailable resource. The name, type of resource unavailable and the reason is also provided by DB2

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain sorting techniques in cobol program? Provide the sort file definition, the sort statement, its syntax and meaning

880


A table has two indexes defined. Which one will be used by the SEARCH?

1034


) what is the difference between AID and HANDLE AID?

1905


What is the difference between perform … with test after and perform … with test before?

1170


For rewrite, why is it mandatory that file needs to be opened?

855


How you can characterize tables in cobol?

941


1.Is it possible to move the data from 99.99 to 99v99? 2.What is the CICS-vsam Compilation process? 3.In My GDG 5 generation will be there GDG3 got an abend what will happen? 4.In my GDG first generation is +1 And I want to add the new generation what will happen previous generation? 5.How can you give the PIC clause below conditions A). s9 (reddy), B). s9 (5) occurs 5 times? 6.How override the proc from a particular step? and what is symbolic and override Procs?

5612


how can i see junk values in dclgen or in hostvariable of comp ?

2770


Explain how to differentiate call by context by comparing it to other calls?

927


INREC AND OUTREC? HOW TO SPLIT 5K RECORDS TO DIFFERENT FILES IN A FILE IN COBOL? RESTART IN COBOL-DB2? ISOLATION LEVELS?

638


What is the difference between PIC 9.99 and PIC9v99?

1048


What is comp-1 and comp-2?

953


input= ,,,, mainframe training ,,, hyderabad .... location.... output1=$ mainframe training in hyderabad location$ output2=**** mainframe training in hyderabad location ****. In this pgn when we give input considering the spaces the output is displayed in this format.Like in the place of ,,,, $ should be displayed likewise.So please helpmeout.

1982


what is amode(24), amode(31), rmode(24) and rmode(any)?

902


How do you reference the following file formats from cobol programs?

934