DSXchange

keshav0307 wrote:this has been discussed may times. try searching in this foroum.

reason being the MOD_DT is not in after dataset.
but what is the error/problem you have?

It has been solved. Thank you.

Gurus: I have 2 key and 3 value columns in after dataset and 2 key and 4 (4th one is modified date) value columns in before dataset. I want to compare after and before datasets using 2 keys and 3 values columns. If incoming row exists in before dataset then I need to bring the 4th value column and a...

Ray: We are getting same error as mentioned above by mansoor.Its function 'utf_to_row()' failed. We have same environment as above. The job runs fine with CPIC method. please thow some light on it. -thanks in advance. The ^M character is probably being interpreted as a line terminator. Can you succe...

I am sorry for the confusion Ray. Actually we have NLS installed and configured. I mentioned Chinese-japanese-korean as an example to explain the problem. But I do not know what type of non-ascii I would be getting. -thanks. If they are Chinese-Japanese-Korean (CJK) characters are you sure you want ...

Hi: How to eliminate a non-ascii charecter dynamically? I mean to say...I do not know what non-ascii char I would get in my source file but i need to search for non- ascii chars and clean up the file before loading into target table. Basically my source file is from SAP. So, I can say non-ascii char...

Kumar: were you able to fix this problem. I am getting same error as below.. main_program: A SIGPIPE signal was received in APT_JobmonFilter::writeMessage caused by closing of the socket on port 13,400; turning off job monitoring for the rest of the job. I really appriciate your time and advice in t...

DSguru2B wrote:Read in the sequential file stage help pdf file about "File Pattern" in "Read Method". I would say its a better way to handle your requirement. It also takes in wild cards and processes all the files.

thank you.

Even easier (and better performing, because you will get parallel operation) would be to use multiple File properties in the Sequential File stage, or to change the read mode to "File Pattern" and specify a regular expression to select the files. thanks Ray. I am unable to locate a 'Multi...

Even easier (and better performing, because you will get parallel operation) would be to use multiple File properties in the Sequential File stage, or to change the read mode to "File Pattern" and specify a regular expression to select the files. thanks Ray. I am unable to locate a 'Multi...

Use the cat command in the Filter options in the sequential file stage properties. Funnel Stage can get you what you need too. thanks guru. If I go for 'funnel' I guess, my job looks ugly with '12' source stages. I could not understand the 1st option. If I am not wrong, in sequential stage properti...

I have 12 source files as

file_1,file_2,....file_12.

I want merge them all to create a single file say 'file'

Is there any such stage in DataStage where we can give all input file names and get the merged file as output.

Basically I need 'cat file_1,file_2 .....file_12 > file'

Helo all, I am trying to full outer join 2 seq. files ( each contains approx. 30 mil. rows ). My job looks as below.. File_2 | | file_1------Join -- Trans-----Seq.File. Job is getting aborted with following errors... Copy_of_Merge_file,0: Export failed. Copy_of_Merge_file,0: Output file full Copy_of...

Anyway thank you Guru and all.

DSguru2B wrote:Not that i can think of right now. Maybe someone else knows and will shed some light on it.

I got it. thanks Guru. one last question. Is there any way that we can write last record with count to output instead of having a sort and Remove Dupl. stages after transformer. And thats where you are going wrong. You need to partition it by keys. Do this, provide Hash as partitioning and choose th...

'Auto' the default one.

DSguru2B wrote:In the transformer, go to the stage properties, what partitioning are you providing?