DSXchange

HI when i compile iam getting the following errors Compiling: Source = 'DSU_BP/DSU.LOCDUP', Object = 'DSU_BP.O/DSU.LOCDUP' ? 0005 a = DSExecute("UNIX","wc -l /xyz.txt", Output, SystemReturnCode) ^ ',' unexpected, Was expecting: '!', ')', '=', "AND", "OR", &quo...

HI, Can i use the following code to stop the process. Thanks in advance filename = "/xyz.txt" Call DSExecute("UNIX","sort -u /xyz.txt > /xyz.txt", Output, SystemReturnCode) a = DSExecute("UNIX","wc -l /xyz.txt", Output, SystemReturnCode) b = DSExecut...

Hi, Iam using the following before job routine.But my xyz1.txt file is not sorting with the unique values. Any explanation please, thanks in advance Call DSExecute("UNIX","cp /xyz.txt /xyz1.txt", Output, SystemReturnCode) Call DSExecute("UNIX","sort -u /xyz1.txt&qu...

please give me the sample code for CheckYDuplicate routne Thanks in advance I think your fastest and easiest design will be stage variables. Looking at your original post you have a transaction group delimited by two X records. Between these X records you have one or more Y records and you want to m...

i didn't give any constraints on output SEQ File link. I mentioned only the LookUP.NOTFOUND on output hashfile link. Thanks naren Please post the constraints for each of your output links. In the second design, there really is not a constraint on the output link to the hashed file. If you have one, ...

HI

Where can i find the XML Input stage PDF file.

Thanks in advance

i have used your original design to achieve this. but, it doesn't work for me. I got all the source records into output sequential file.Nothing in output hashed file. any explanation please. Thanks in advance So, if you see the same two values more then once, the file is bad. My original design work...

hi where can i find the XML INPUT PDF FILE THANKS IN ADVANCE NAREN There is one crucial design requirement of XML Input - you need to pass it an input link contain a URL or an file path or an XML document. At no point does the XML Pack help file or PDF manual tell you how to do this in a parallel jo...

Hi, Let me put my requirement in this format. I have seq file with 2 columns SEQNO and SECNO. For One SEQNO We can have multiple SECNO'S. But not same SECNO.If I get the file like below i need to reject the file.Because for the SEQNO '001' we have same SECNO '001' SEQNO SECNO 001 001 001 001 002 001...

hOWTO SPECIFY THIS HashedLookup.NOTFOUND IN CONSTAINT

The constraint on the write to the hashed file is: [/quote]

HI, MY SEQ FILE LOOKS LIKE XHHA00691473400000000000001 YHHA00691473400000000000001 ZHHA00691473400000000000001 ZHHA00691473400000000000001 YHHA00691473400000000000001 ZHHA00691473400000000000001 ZHHA00691473400000000000001 XHHA00691393500000000000001 YHHA00691393500000000000001 ZHHA00691393500000000...

hi
job name is GetFNames only. typing error

ray.wurlod wrote:If the job name is "GETFNAMES" then this is the name you must use in DSAttachJob, not "GetFNames". Job names are case-sensitive.

Actually in my first job GETFNAMES iam getting the filenames from the folder to sequential file. Then i want to read those filenames and based on filename or substring("filename",1,2)="xy" i want to call other job. Until the end of all filenames. Am i doing in the right way?. Any...

hi

Hi , Following is the my job control routine. * Setup GetFName, run it, wait for it to finish, and test for success hJob1 = DSAttachJob("GetFName", DSJ.ERRFATAL) If NOT(hJob1) Then Call DSLogFatal("Job Attach Failed: GetFName", "JobControl") Abort End ErrCode = DSSetDis...