DSXchange

I was able to resolve the issue in a couple of jobs. I was using the SybaseOCPX stage with "Generated SQL query". However, I didn't have the "database owner" with the table name. Thus instead of using "Owner.dbo.TableName" in the "Table Names", I was using &q...

In a server job, I want to extract data from a SAP table using ABAP Extract stage. It works fine if I want to extract entire table. Or With the where clause with hard coded value to query. where col1= '2006' works fine. Problem is we need to limit this extract with parameter value. ie where col1 = '...

ArndW wrote:kunj201, are you asking what this program does? ...

well...yes. Also, the major concern is over the 1at arg of pParameterList...what is the format of it, what info it should be included, where to store and what it does

Thanks,
Nikunj

kcbland wrote:Could you please edit your post and put code tags around the logic so I can read it? ...

Sorry about that...I edited it..pls reply. thanks again

Can you explain what formate is the aParameterList and what is does? * Call Archive routine to move files from working directories to ThisBatchArchive_dir and compress. * ArchiveFiles(pParameterList,JobName,Output_file,pThisBatchArchive_dir) * The ArchiveFiles routine will figure out which files in...

A Sequence with Command stages, a Batch job with DSExecute API calls, make your choice. ... A batch job. Again, the file generation will be dynamic. ie.. For jan run, it will have one Ins_XYZ_1.xml... but for march run, it will have Ins_XYZ_1.xml,Ins_XYZ_2.xml, Ins_XYZ_3.xml... Also might have Del_...

Hi there, I need to move file from working folders to a shared drive. I need to look for all .xml files in 3 directories from data stage file directories..ie.. e:\data\dev\folder1, e:\data\dev\folder2...folder3 and move them to a shared directory outside datastage server. I have a network shared loc...

Got the solution... :lol: a BIG thanks to all for your time and efforts.. Here is the ultimate solution.... The error above was eliminated by use of new function with the code: $INCLUDE DSINCLUDE JOBCONTROL.H DEFFUN UtilityHashLookup(Arg1, Arg2, Arg3) CALLING "DSX.UTILITYHASHLOOKUP" * NOTE...

Ok. Lets devise an easier solution to get the month. Is your cycle going to run after the first day or on the first day of every month. IF yes then instead of using $counter, you can just do, UtilityHashLookup('Fully qualified path of hashed file",Oconv(Date(),"DM"),1) I have tried t...

No pound/hash signs... and you need to qualify the counter with the name of the stage it comes from: Start_Loop_Stage_Name.$Counter When I use in Manager to test the routine UtilityHashLookup....it says table not found... Is it really a table or file?? Do I need to specity option while creating thi...

DSguru2B wrote:You dont need to pass $USERSTATUS. just the hashed file name. And yes pass the $counter as the key to the utility.
Do this

Code: Select all

UtilityHashLookup(HashedFileName, #$counter#,1)

UtilityHashLookup('H_Area_ICM_Period', #$counter#, 1)

Same error...

Routine: ReadHashFile(HashedFileName, HashedFileKey, FieldToReturn, ValueReturned)..... ...Then use a stage variable to set to ValueReturned..... K i have loop..so loop will run from 1 to N period... I can have $counter as parameter that I can use for lookup against Hash file.. hash file: 1 2006-01...

...stashes that value in the job's USERSTATUS area. Any job downstream from that job in the Sequence can use the $UserStatus value to feed a job parameter rather easily. Seems very fesible option to follow... Please let me know how exectly I attach that value in job's userStaus area ? Option 2: ......

How exactly have you done .... Thanks for a quick reply..damn good... yes I am using the start loop/end loop act in seq. I can take $counter and go against hash to get begin date for that period...but how do I get that begin date to be a Job parameter? Hope you get it..and its fairly easy :) actull...

After several hours of search, i found a very close help.. http://www.dsxchange.com/viewtopic.php?t=100588&highlight=passing+parameter Please Let me know if that is applicable in my scene... I need your help here! What I have done: I have a loop where I will process each month per run. So when u...