DSXchange

Declare in the input as VarChar - unless you have NLS enabled.

I probably got the syntax wrong. Look at the BASIC manual PDF for the exact command, it might be ON ERROR (actually, now that I think about it, that is the correct form)

akrzy,

so what happens when you run the code with the ON.ERROR, does it enter that branch?

Does the C:\DS305FILES directory exist (i.e. what happens if you just try to open C:\test.txt?

Could you change your .XML source file to have 1W-NR (1 writer and N-readers). I'm not at a system right now where I can get the correct syntax for you. There should be no reason that a sequential file could not be read by n processes simulataneously, and I think the error you are getting is because...

Although the last thing I want to do is simply post an answer to an interview quesiton, I think that this is silly enough to warrant an answer and that some of the members here might be interested in an answer. The underlying Server engine is a UniVerse based system. The programming language used in...

Hello itconsulting, my first question is to ask whether or not you have DRS installed - I know a program should never hang but at least it would go a bit towards explaining your problem. Does the Designer actually hang (meaning "not responding" status in windows) or does it just not return anything.

akrzy, Your code basically tries to open a sequential file and if it is not already there it will specifically CREATE an empty file. At least that is what is supposed to be happening. Do not use the ABORT command, the preferred method of stopping any DataStage job from continuing is to call DSLogFat...

Devyani, If your function works like ParamValue = ReadFromParameterFile(ParameterName) then in your case you would write a DataStage sequence with a routine stage that retrieves the parameter value you want to use, then in your Job stage you would use that variable to pass in the parameter value. Th...

Tytoi, as you are calling the end-of-job subroutine from within you job itself, it will always return the status of "running"; in order for this to work you need to get the status after it completes. If you start and run your job from a sequence or from a Job Control, the status of the job will be a...

Hello Devyani, there is a difference in how you do this depending upon whether you are writing a DataStage function or a before/after Routine. With functions you can declare any number of arguments and one function return value. So you could declare an input parameter for each of the values that you...

Usually the access violation$ error stems not from OS level file access but from memory access problems - a program is trying to modify a virtual memory address that is read-only [most commonly it is the code portion where an errant reference points to]. A quick look at the code shows that the error...

Hello Lindies,

this behaviour is consistent with COBOL signed datatypes. Just make sure that you use the same datatype in DS as the Cobol PIC clause and it will be handled correctly.

If someone did an "rm" inside the directory, the .Type30 file must have disappeared. I the .Type30 disappears, then DS loses the information about what type of a file it is - so it will assume that it is a Type 1 or 19 file, and each write to that "file" will create a "record" (UNIX file) with the ...

Shyu, the "Account Name" option will tell the DataStage process to attach to that account directory (it knows where that is located on the system by looking up the entry in the UV.ACCOUNT file) and then looking into that account's VOC for an entry for the given hash file. This VOC entry will contain...

Lance - I couldn't think of another way to do it easily, at least in Px.