What is SQL Code -904 and -903 in DB2 And how to handle it?
Answer / 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 |
input:- 12233344445555566666... output:- 1=1,2=4,3=9... Here firstno i.e 1 should be displayed and after that the alikeno.s should be added n displayed.i.e 2+2=4 like tat it goeson.
How to display string in the reverse order using occurs clause?
What is the output generated by the following code? 01 GRP-I. 05 SUBFLD1 PIC XX VALUE "AB". 05 FILTER PIC X(6) VALUE SPACES. 01 GRP-2 REDEFINED GRP-1. 05 SUB-FLD2 PIC XX. 05 SUB-FLD3 PIC XX. 05 FILTER PIC X(4). IF SUB-FLD1 NOT = SPACES DISPLAY "SUBFLD1" MOVE "ABBCCD" TO GRP-1 IF SUB-FLD3 = SPACES DISPLAY "SPACES" ELSE DISPLAY "SUBFLD3" DISPLAY "END" ELSE DISPLAY "SPACES" DISPLAY "END". (a) SUBFLD1 SUBFLD3 END (b) SPACES END (c) SUBFLD1 END (d) SUBFLD1 SPACES
input 1 input2 ouput1 output2 output 3 1 re 300 1 re 200 1 re 300 3 rc 500 1 re 200 2 rr 400 1 re 300 2 rr 400 1 rc 400 3 rc 500 1 rc 400 2 rr 700 2 rr 700 5 tt 900 5 tt 900 2 inputs r in flat file and output 1 is matched records,ouptput2 is unmatched of input1,output3 is unmatched of input2! how vl u get the output files using sequential order and to check with each and every records! let me know the procedure division ?
Explain about different table spaces.
SIGN TRAILING SEPARATE field occupy ?
What is an explicit scope terminator?
What is the difference between a binary search and a sequential search? What are the pertinent cobol commands?
How to find whether a Flat file is empty or not without Reading a file in COBOL Program. (not using JCL)
i want to enter the name 'pandu' into ur table how?
What is SET TO TRUE all about, anyway?
Can anyone please give the example of Inline Perform.