DSXchange

Pretty good video. (+) Points - Good topic to go on with - Flash working fine again. - Learnt a few things as well. (-) Points -Text was not as clear ie; more grains. - Pace is a little too fast. Imporvements: - Subtitles are good to have - Larger flash screen I wonder what application you are using...

As Craig requested, please provide all possible formats that you can get. This way it will be easier to us to point you in the right direction, even a possible solution.

I agree, i guess thats enough options for the OP to pick and choose from.

Mahi_mahi, just created an in-account hashed file. If that is against the standard use at your client, then create a VOC pointer by using SETFILE <fully qualified hashed file name> VOC pointer Name Then in the UtilityHashLookup() pass the pointer name as hashed file name. That should take care of it.

Or, load the data into a hashed file (in account) with a dummy key thats nothing but a sequential number. Then access that hashed file via universe stage and run the sql query on it.

And if its a signed field, then you will use DataTypePicS9() function.

Sorry . Did not pay attention that it was a TX question.

Ken is right. For 2300 rows, a loop would take for ever. Make your jobs multi-instance. And if you got my approach, you can eliminate the loop activity and just run the same multi-instance jobs by giving sequential invocations ids which will be used as keys in the UtilityHashLookup(). This way you c...

What Ken is trying to say is, that the best way to handle this is to design everything in sucha way, that once you fire off your job or sequence, it should handle all the values from csv file. Right ken? If you ask me, i would load the csv file into a hashed file and add another column as a dummy co...

Or use the Field() function.

if you have the field position then use the substring functionality to split the data.

I dont know at the back end but you could specify it in the name so that your script can tell by the name of the sequence whether its restartable or not. OR you can make all your sequences restartable and the ones you "dont" want to be of restart nature, check the box "Dont checkpoint run" in the jo...

Usually checking for null from a flat file is hard unless it has the control character ^@ which represents a null. Usually flat files dont have such un-printable characters or they are stripped implicitly. Thats why a null check wont work even though to a naked eye it does look like null. Thats wher...

What do you mean by job details. Look into the DS functions. Like to get a list of jobs present in a project, you will use DSGetProjectInfo(DSJ.JOBLIST). But this will only give you the job name of that particular project. Look at the function DSGetJobInfo(). But i highly doubt you can do that for d...

for null check for isnull() = 0 and for empty string use the len() function. By those two functions you can handle it.