IBM Rpg iv with ile 認定 000-268 試験問題:

1. Given the following code segment:
AAN01N02 N03T.Name++++++RLen++TDpBLinPosFunctions++++++++++++++++
A R D1SF SFL
A OPTNBR 1A B 10 3
A SCNDTA 50A O 10 7
A R D1SC SFLCTL(D1SF)
A 79 SFLDSP
A 81 SFLDSPCTL
A SFLSIZ(1000)
A SFLPAG(0011)
A 9 2'Opt Data
What DDS keyword needs to be added to this code segment to remove all of the records from the subfile?

A) SFLINZ
B) SFLDLT
C) SFLRMV
D) SFLCLR

2. Which of the following pieces of information can be found in a trigger buffer?

A) The name of the file and the User profile of the job which caused the trigger to fire
B) Name of the physical file member being processed
C) The name of the logical file member being processed
D) Name of the record format being processed

3. Which of the following represents the sequence of embedded SQL statements required to extract multiple records based on criteria that are not known at compile time?

A) PREPARE statement, EXECUTE statement, SELECT row(s), FETCH row(s), DROP table
B) DECLARE cursor, OPEN cursor, SELECT row(s), FETCH row(s), CLOSE cursor
C) PREPARE statement, DECLARE cursor, OPEN cursor, FETCH row(s), CLOSE cursor
D) DECLARE cursor, EXECUTE statement, OPEN cursor, FETCH row(s), CLOSE cursor

4. Given the following code segment:
DName+++++++++++ETDsFrom+++To/L+++IDc.Keywords++++++++++++
D GetBalDue PR
D Balance 11P 2
D CustNo 5S 0
D Qty 7P 0
D Amount 5P 2
D Balance S 11P 2
D CustNo S 5S 0
D OrdQty S 7P 0
D Amt S 5P 2
Which of the following contains correct syntax?

A) C CallB 'GetBalDue' C Parm Balance C
Parm CustNo C Parm OrdQty C Parm
Amt
B) C Eval Balance = GetBalDue(CustNo : OrdQty : C
Amt)
C) C CallP GetBalDue (Balance: CustNo : OrdQty : C
Amt)
D) C CallP 'GetBalDue' C Parm Balance C
Parm CustNo C Parm OrdQty C Parm
Amt

5. Given the following code segment:
H DATFMT(*YMD)
D Date1 S D INZ(*hival)
D Date2 S D DATFMT(*USA ) INZ(D'95/04/30')
D Date3 S D DATFMT(*ISO ) INZ(D'04/03/02')
D Date4 S D DATFMT(*USA )
Which date will the following statement produce?
C EVAL Date4 = Date1 - %Diff(Date3:Date2:*Y)

A) Date4 = '31/12/31'
B) Date4 = '12/31/2031'
C) Date4 = '12/31/9991'
D) Date4 = '91/12/31'

質問と回答：