IBM AS400 AllOther Interview Questions
Questions Answers Views Company eMail

Can anybody please tell me what is difference between SQL (STRSQL ) and WRKQRY .....?

3 18417

Hi All, Can any one give me a suggestion for below prob One job is in MSGW due to decimal dara error and I find out stmt error and Value in DMUP. but my file has millions of records.So how can i find out on which record the error was occured....?

3 9504

Hi friends i have i question please reply me asap. what would be coding in DDS and programing part for this condition suppose that i have three fields in the display file(subfile)which has 7 record format. Condition is ''The supplier LOT, ISSUED TO PROD and LINE GRP fields in display file(Subfile) will not be shown if their respective fields are blank/zero in the record formats WIM311FM and Record format WIM311FM. I want coding part in DDS and Programing. Please reply me as soon as posible.

IBM,

1 4039

How I can read and display three fields in the record format DSPFM1 of the display file,while one field(using in one file) is NAME which is Key field in field reference file and another two fields are AGE and ROLL NO are using another file. Please send me coding part.

IBM,

2 6510

Q.Hi All friends, I have one Question, I have three fields in display file SUP LOT, ISSUED to Prod and Line Grp. Field SUP LOT is mentioned in one field reference file WRSLT and key field as a key field LP.Fields ISSUED to PROD,Line GRP are mentioned in the another Field reference file WMDTF. So I want to read SUP LOT on the basis of key field LP from the first file WFSLTand then i want ot read another two fields ISSUED to DATE and LINE GRP from second file on the basis of SUP LOT, which i got from first file.Now i want to display these fields in the display file DSPWMMS. but Condition is that 'Supplier Lot,ISSUED to Prod and Line Grp will not be shown if their respective fields are blanks/Zero. Please Let me Know coding part of this senerio and what would be coding for display file to now shown fields if fields are blanks/zero. My mob. no. is 9836300345. Please reply me asap.

IBM,

1 3264

Hi Friends, I need immediately answer for this: Senario is that,I am selecting records from the display and window subfile on the basis of Reason Code and some more fields but spool file not showing the same records which i have selected by display and window subfile. Q.What could be the causes(resons)to not show records properly (just selected in the display file and Window subfile)according the selection criteria of the records. Q.What would be the solutions to show records properly in the spool file just as selected in in the display file and window subfile according to the selection criteria.

IBM,

1 3841

Q1. How to use signature in service program and ILE.? Q2.what is use of signature and binder language and what is the relation between them?

CTS,

2 31390

Any change in service program we write binder language to allow signature change,What is the maximum number of signature change allowed in RPGLE?

Syntel, Tech Mahindra,

3 8949

we have 2 PF files with same name, how to copy data's from one file to another through RPG program logic?

3 18130

I have 1 rd in my flat file. say reord from 1 to 10 position : 'AS400NDB2400' I need to change the value from N to Y using SQL stmt ...How can I update this....?

5 7887

If login Screen has been modified by adding current date to be displayed. What Step to be followed to Keep that date as Current date Note: If no steps taken then it will display only the compilation date

BridgeStone,

2 5638

Is LDA can be access accross the Job?

9 12519

What is the difference between keys of a Physical file and the keys of a logical file?

Bank Of America, BoA,

2 8830

What are the steps to retrieve the records from Journal file...?

1 10887

STRTCPFTP command is used to start FTP in CL Language (ILECL)....can u plz tell me which command is used to start SFTP in CL language(ILECL)?

1 10679


Post New IBM AS400 AllOther Questions

Un-Answered Questions { IBM AS400 AllOther }

Why we have multiple data types in As400 and why we use numeric, packed, decimal, zoned the basic difference between this?

600


using dfu, user will be able to ___________ from physical file?

566


how to define to define a hidden filed in dspf ?

762


is it there an easy way to determine if an html section is available to issue a wrtsection upon?

551


what is elastic and non elastic subrile?

553






records can be read/update/deleted with which file?

616


If I want to execute Sftp commands(LS & GET) stored in Physical file from CL program automatically...Can u Plz tell me how can I do this?...How the script will look?? THANX FOR NY HELP...

2169


what is the purpose of indicators in rpg?

1052


Can you summarize the steps I have to go through in writing my first cgi?

605


define the purpose of the %sst function?

918


Service Program : S1 Modules in S1 : M1 M1 having two procedures : ADD, SUB Current Binder Language STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP Doubt: I need to add one new Module to the Service Program M2 having one procedure ‘MULT’ How to add this new module to the service program S1 ? If I need to recreate the service program again, Do I need to mention the Module M1 again while recreating along with new Module M2? There is no Binding Directory. Binder language structure will be like this STRPGMEXP PGMLVL(*CURRENT) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") EXPORT SYMBOL("MULT") ENDPGMEXP STRPGMEXP PGMLVL(*PREVIOUS) EXPORT SYMBOL("ADD") EXPORT SYMBOL("SUB") ENDPGMEXP

1920


how can we run a batch job?

721


what the purpose of ovrdta, ovrata keywords?

1152


which are the query selection criteria, which can be given in a query?

659


maximum number of subfiles that can be active for a single file is?

960