DSXchange

Pass the two files as a file pattern in sequential file and load it into a sequential file,it would resolve your problem.

Thanks a lot Arnd.I was learning to use different string functions but always getting stucked at dynamic arrays related function.I thought dynamic arrays are arrays with no fixed length but if it is an string with special delimiters.Are the special delimiters in datastage a combination of characters...

Hi Arnd, The syntax in transformer is Remove(%string%,%delimiter%) whose syntax in basic language is Remove(dynamic.array,variable).It says in basic language that it extracts & returns the dynamic array elements from system delimiters.I have provided the variable as 2 in the above example but st...

Hi All, There is no documentation of remove string function,so can anyone tell me how to use it.Mean while I have tried to experiment by running the following function remove("toronto:canada:na",":") ,though this function is being accepted in the transformer but when it is being ...

Thanks a lot Ray but i think first i need to brush up myself with what is an dynamic array.

Can anyone help me out how does an extract function in server transformer stage work.I have tried with different options being passed for example Extract("dsxchange",1,2,2),it runs the job properly but returns null value.

Hi Jamshid,
Can you tell us in more precise way like what exactly are you trying to do.

Cheers,
Rajeev.

Hey vmcburney,
Thanks vmcburney i was just looking at the statement said above that modify is more efficient and trying to look if there is any such string function which serves the purpose thats it.

Cheers,
Rajeev.

Hi Ray, This is how i did it i have taken an input column by named name which contains data in the format MAN,LANGUAGE.Now i have used the modify stage with the following string function in this manner ouputname:string=field(name,",",1) where outputname is the name of the output column.But...

Hey carol,
Iam sorry i didnot read it properly that it was regarding server jobs.

Cheers,
Rajeev.

Hi Ray,
I have used string function field in modify but that didnot resolve the problem,can you be more specific like what type of string functions shall i use in modify which would be more effective than transformer stage.

Cheers,
Rajeev.

Hi Alink,
As to my knowledge the workaround for it would be to upgrade your present DS installation with NLS option.

Cheers,
Rajeev.

Hey Carol,
One of the way of improving the performance of DataStage jobs is by pointing the different nodes to different paths in the configuration file provided you have enough disk space in the pointed locations.

Cheers,
Rajeev.

Hey vmcburney,
You can try the following thing in transformer stage
field(inputcolumn,",",1).This would give you the string before , i.e MAN as per your example MAN,LANGUAGE.

Cheers,
Rajeev.

Hey King, Jobs from Informatica to DataStage can be converted using DataStage MIgrator tool(IBM Asc tool).But the jobs would be converted into server jobs. Cheers, Rajeev. Ascential set up a team of developers to convert PeopleSoft EPM customers across from Informatica to DataStage when PeopleSoft c...