:: Home Page      
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
 Categories >> Software >> MainFrame
  IBM MainFrame (3245)   IBM AS400 (628)
Suggest New Category 


Question Asked @ Answers Views     Select
Q4. How will you get the count of record without using COUNT verb in query?    0  6
Q3. How will you fetch duplicate values from a DB2 table?    0  5
Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program.     0  5
Why we us SYSTSIN DD with IKJEFT01 (TSO Utility) to execute a COBOL DB2 program? Why can't we use SYSIN DD?      0  6
how to get the particular field's records in CL without using OVRDBF,OPNQRY? tell me the concept?    0  7
A STEP has more than 1 file as INPUT. And we have to put all these records int 1 output file. How to do ? //InputF  DD DSN=ID.File1              DSN=ID.File2              DSN=ID.File3    0  12
Current version of GDG is ID.GDG.FILE.G0001V00. JCL has procedure with 2 steps like below,  What will be the output file name in each step ?  PROC starts      Step 1 has ID.GDG.FILE(+1)      Step2 has  ID.GDG.FILE(+4) PEND Similarly, JCL has 2 steps in 2 separate procedure. What will be the output file names here ?  PROC starts      Step 1 has ID.GDG.FILE(+1) PEND PROC1 starts      Step2 has  ID.GDG.FILE(+4) PEND    0  11
I have created a command that display Source file and library. Now i want that when i enter library name and press f4 on Source file, pgm should display all the PF- SRC's in that Library. For F4 option i have used Choice program but since only limited paramters are passed in Choice pgm i am not able to paas library name and further can't call a pgm that will display list of Source files. Below is the Code snippet for CMD type object :- CMD PROMPT('Source Scan for HUB Standard') PARM KWD(SOURCE) TYPE(*CHAR) LEN(1) RSTD(*YES) + VALUES(N A) MIN(1) + CHOICE('N,A') PARM KWD(SRCFILE) TYPE(FILE) RSTD(*NO) + PROMPT('SOURCE FILE') FILE: QUAL TYPE(*NAME) LEN(10) RSTD(*NO) EXPR (*YES) + CHOICE(*PGM) + CHOICEPGM (XXXXXLIB/YYYPGM) QUAL TYPE(*NAME) LEN(10) DFT(*LIBL) + SPCVAL((*LIBL)) EXPR(*YES) PROMPT ('Library') Below is the Choice pgm:- PGM PARM(&PARM1 &PARM2) DCL VAR(&PARM1) TYPE(*CHAR) LEN (21) DCL VAR(&PARM2) TYPE(*CHAR) LEN (2000) IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + 21 1) = 'P')) THEN (DO) /* (%SST(&PARM1 21 1) = 'C' *OR %SST (&PARM1 + */ CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') ENDDO IF COND(%SST(&PARM1 1 10) = 'CHOICE ' *AND + %SST(&PARM1 11 10) = 'SRCFILE ' *AND + %SST(&PARM1 21 1) = 'P') THEN (DO) CHGVAR VAR(&PARM2) VALUE('Name, F4 for List') CALL PGM(GTSQL) PARM ('XXXXLIB') return ENDDO Thanks in Advance for looking into. hsbc   0  26
The natural file converted to PDF file if Yes then explain ?    0  29
There is subprogram and which is used in more then 200 modules. when we made changes to subprogram is it required to RESTOW all the main programs? If YES means how i can restow all 200 main programs at a time. hcl   2  76
Hello, I have created a CMD type object. In one of the fields in Display file , I would like to see All the Source files present by pass the name of Library. Tried using CHoice(Keyword) and Choicepgm on PARM , but doesn't seems to be working. Any help please.. blackrock   0  20
How can you add a particular field/coloumn in copybook? l&t   1  69
How can you add a particular field in copybook? l&t   0  35
How we can see the Data in IMS Database? hp   1  81
1)In a pf if we delete a record then how to insert a new record at the same place in that pf?? any logic or code? 2)A batch job is taking a lot of time to run,found that it is going into loop and wrapping up so how to skip that loop and process the job without changing the code? 3)In which scenario C D I R comes and C D G F comes in a job? 4)If a job came to error while processing a file how we can know at which record the error hit and how to skip that record and process other records without changing program code? jda   0  64
E-Mail New Answers        Answer Selected Questions       
 [1]    2  ... 19   ... 37   ... 55   ... 73   ... 91   ... 109   ... 127   ... 145   ... 163   ... 181   ... 199   ... 217   ... 235   ... 253    Next
Un-Answered Questions
 Question Views   Select
How to define a array dynamically..... 975
how many maximum no of variables can be declared in linkage section ? 285
whats the diff bw the evaluate also and and? 295
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... 560
how to move the records from file to array table. give with code example 282
Which command is used to replace CDUP command in FTP IF i WANT TO USE SFTP? 195
is it compulsory commitment control in journal? 249
how can i see junk values in dclgen or in hostvariable of comp ? 454
have in 100 records in a file i want to read first 3 records and skip next 3 records and agan i want to read 3 records and again i want to skip 3 records... 1362
Matching Logic in Jcl not in cobol.Could any one please answer this question 832
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records? 1257
what type of version is we r using now real time in all modules(cobol, jcl, cics, db2, vsam)? 254
what u mean by csrloc and rtncsrloc in rpgIV in as/400.Give an eg? to do...give some coding...what is row no and column no ???..if possible...give a no of lines coding....please 1260
what is the difference between call and ++call? 367
How do we pass parameters into a CICS –DB2 program 316
E-Mail New Answers        Answer Selected Questions