DSXchange

Hi Ray, Thanks for your prompt response.How can i know the no of partitions in my job since i am using auto partioning and also since it is a fixed width CFF i didnt use any delimiter.But i used the option of read from multi node. i used the same file of different size it is working fine.

hi ,
I am getting the following error

"sample_CFF,1: Cannot use multinode: The file length (1146600) is not a multiple of the record length (716)"

when do we get this error.I am using DS EE7.5 Complex flat file

Hi, I have a scenario where i will be getting a source which is a result of appending of 2 files. Now when i read the file in datastage i have to split the file into 2 different files. The file has 2 headers and the data from the first header to the starting of second header should go to one file an...

Hi,

My job design is as below

SEQ---------->Xfm-------------->Dataset

when i Run this job it is giving the following error
what is thie error and when do we get this error

I think you need to gather stats. What is your average number of stages? What is your average number of columns per stage? What is the most used stage types? All concepts like simple, medium and complex should be based on stats like average and standard deviation. We had lengthly discussion about t...

Hi, Can we use ICONV and OCONV for these date conversions??? if the data is Jan 12 1995 then the result would be ICONV("12 Jan 1995","D4-DMY[2,A3,4"]>=0 OCONV(0,"D4 YDM[4,2,2]">= 1995 1 12 Hope this helps. Lalitha ICONV and OCONV are used in server jobs not in parallel...

i used the same code mentioned by INFO_DS ( mydate= 'May 12 1995 12:00:00.000 AM' DateToString(StringToDate(mydate[1,11],"%mmm %dd %yyyy"),"%yyyy%mm%dd")) it is working fine on soalris machine.But when imoved the same code to Pre production environement (HP-UNIX) i am getting the...

Hi,

In one of my jobs i created a dataset and in the other job i tried to read the same dataset which i created in first job i am getting the following error:
What does this signify.

Doesnt Work! -->mydate= 'May 1 1995 12:00:00.000 AM' if u want the above part to work use a convert function to convert all the spaces to 0 and then apply the functions DateToString(StringToDate(mydate[1,11],"%mmm %dd %yyyy"),"%yyyy%mm%dd") on the converted datecolumn .[/code]

This is a string manipulation type operation, no real date mapping is needed. If your input date is in January as you stated and with your InString format as given you could do a In.InString[4,4]:'01':In.InString[1,2] to achieve your request result. sorry the input is going to be like this Jan 12 1...

This is a string manipulation type operation, no real date mapping is needed. If your input date is in January as you stated and with your InString format as given you could do a In.InString[4,4]:'01':In.InString[1,2] to achieve your request result. but my input date is not going to have month as j...

Hi,

My input is Jan and i want the output to be yyyymmdd.How can i achieve this.

Hi,

what is the equivalent for folder stage in server to Parallel.I am trying to use XML Input to read data from xml file it is expecting an input link in server job there is report stage.What is the equivalent of it in parallel.How can i go about using XML input in parallel jobs.

Hi, I am Trying to execute a sample parallel routine that comesa long with the software for solaris. I am getting the following error Transformer_5: Failed to load the library "V0S5_TrxFuncExampleStatic_Transformer_5.so". Either the directory containing the library file is not on the libra...