Hi Every one, I have a scenario plz suggest me 1)On daily we r getting some huge files data so all files metadata is same we have to load in to target table how we can load? 2) One column having 10 records at run time we have to send 5th and 6th record to target at run time how we can send? Hi plz help me for above scenarios and If any one is having JobSequence kindly send me one example and the scenario to my mail ID(nrvdwh@gmail.com)
3 10515How to open VSAM file from 3.4? i have millions of records and i dont want to use the print ch ids(/) command bcz it takes to much time. so if you have any another command to open this plz tell me.
2 24648I 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.
1 3603Post New HSBC Interview Questions
hello can yoy pls send me previous papers of jindalpower and steel ltd.....'m from instrumentation..... mani1048@gmail.com
How do I make the mouse cursor invisible/visible?
Write a program for Sorting an Array. Which sorting will you prefer?
I am looking for pattern & questions of NIC exam. If anyone knows it pls send it to sveera_jkm@yahoo.co.in Thanks
What is the current latest version of scala? What is the major change or update in scala 2.12?
Please send the clerical exam questions and answers to my mail Id pinky18.02.1985@gmail.com
please send me latest & previous years question papers for IOCL Technical level questions
Where do we get the QTP and Load runner softwares CDs ( Original ) in chennai
Can free-form SQL queries be used with Sqoop import command? If yes, then how can they be used?
Why you do not refund the customer his money for the extension? It was agreed, that you pay it back!
hi actully i hav form columns with origin and destination names .as like as i need to create one more column with name amount. my requirement is when i select origin and destination columns automatically i need to get amount from database.how can i. please tel me with relative code
What is the latest angular?
Tell us about your hobbies.
How to retrieve images in sql server database through vb.net?
How to add default rules in transformer?