DSXchange

I was trying to open the VOC file but it was not in a readable format (As said by Arnd, that VOC entry will contain3 lines). Could you please tell me how to view the contents of VOC file? Also how does it assist in migration of code across projects? Shyju, the VOC file is itself a hash file and can...

I found DSU.DSJobReport in the project, and it takes 2 parameters - but I couldn't find it described anywhere in the docs. Are you sure you don't want to call the documented DSMakeJobReport(JobHandle,ReportL,Separator) instead? You can only call one after-job subroutine, but you can always have your...

Glad you got that sorted out!

ewartpm, did you copy the I-descriptor from your file to the VOC? I did the following test: 1. CREATE.FILE AW1 DYNAMIC 2. CREATE.FILE AW2 DYNAMIC 3. ED DICT AW1 dfkey 01 I 02 IF @ID[1,1]='1' THEN 1 ELSE 2 ... 05 3R 4. LIST AW1 dfkey {to force a compile of the I-descriptor} 5. COPY FROM DICT AW1 TO V...

Hello Atanu, the DataStage product gives you many different options for accessing the job logs. This subject has been discussed several times, I did a quick search for "save log information" and got many hits. One common way of accessing the log data for a job is to use the OX level dsjob command. T...

ewartpm -> The I-type needs to be in your VOC file, do a "COPY FROM DICT <PartfileWithItype> TO VOC akakey" and then do your "BUILD.DF ..... INTERNAL akakey"

And to add to your last open question - the algorithm that returns the part number is an I-Type, which is a compiled expression and can contain or use any part of the record, but usually is restricted to the key column.

Phil,

you use it. I just did a quick server test job using NOTFOUND without issues. Perhaps you could explain the problem you are having...

Try renaming your column from "A" to another name, preferably one that is not a reserved DataStage keyword and see if you have the same problem.

akrzy,

you need to be careful with Windoze paths that have embedded spaces in them, but the sample file you mentioned, "C:\DS305Files\RecentEmployeesBASIC.txt" should work. Please remember that the file is going to be created on the [b]server/b] path as specified, not on your local client pc.

Do you mean a "SELECT" to a remoted database (ODBC, or direct DB connect) or to a Hash file? Since routines tend to get called often, quite frequently once per row of data, doing any type of a SELECT will be extremely slow - considering the enormous overhead involved in connecting and opening up a D...

I should have elaborated, the VarBinary datatype is used to store information in a variable length format that is not to be interpreted as belonging to any given character set. This causes problems, as you have noted, in Px when it tries to do a normal datatype conversion. If you are reading from a ...

akrzy, I agree with what Ray said - but I seem to remember a prolonged thread a coupel of weeks ago about the CREATE statement... I never use it but others argued that it ought to be used. My usual syntax for opening and/or creating a sequential file is: OPENSEQ 'myfile' TO MyFilePtr THEN WEOFSEQ My...

OK, in that case I don't know what the issue in your case could be; the concurrent reads is something I've seen several times before, though.

Ray - thanks for the heads-up!!!! I knew there was a reason for actually referring to the documentation but couldn't remember it