writing an sql statement from selecting records from two files using single statement and nested select statement.
A phisical file has two fields like 1) Account No(10,0) 2)Phone No(15,0)Unique on both fields?Please give me the answer for this?
how you get the relative record in a subfile in which cursor is located?
What is the purpose of the following FORDHDR1 CF E WORKSTN $2SFN SFILE FMT2
what does vldcmdkey means?
What are the mandatory keywords of sub file?
what do we can do with the embedded sql statements?
can we creat a member logical file
How many libraries can be there in library list ?
how to write code for singlepage in sqlrpgle with update ?
Pgm A is invoked through HTTP. It is in Activtion group QILE. Pgm A calls Pgm B and Pgm C. Pgm B is in activation group TEMPACTGRP. Pgm A ends in error. Pgm A is called again. But it gives an error that TEMPACTGRP still exists and files are present in QTEMP. What is the cause and how will u fix?
how to define to define a hidden filed in dspf ?
Write the subfile logic program for the given concept. Load the data to the subfile depends upon the designation where designation is not a key field?