DSXchange

You people are unbelievable. Thanks a lot lshort.

I was stuck up with the same problem. When I used Column Import stage it worked perfectly.

Thanks once again.

Thanks a lot Chulett.

This clears my doubt.

Hi All, I am new in using shared containers. I have read the help guide provided by Datstage. I tried implementing a sample job using it. I just need a confirmation if the metadata(columns) passing into and coming out from shared containers are always fixed. Is it that, they cant be changed across j...

Thanks a lot Chulett for your help.

I read it, but still it is not clear.

Could you please elaborate.

Thanks,

Hi All,

I am very sorry to ask such a basic question.

Can someone give me the exact difference between Record Delimiter and Final Delimiter in setting the Format for the file. When and where to use them respectively.

It seems to be the same for me, but I think there is a difference.

Thanks,

Yah this solved the problem.

Thanks a lot.

But coming back to my original question. Is there any way to avoid repetitive tags to be grouped or is it like it cant be done in Datastage.

Can anyone of you confirm on this.

Hi Please give me a sample structure in setting 2 fields as key for file with 12 columns. I have searched the forum as well as tried implementing myself but nothing has worked. I could find only one topic with respect to keys given by Arnd but that too didnt work. http://www.dsxchange.com/viewtopic....

I face a problem when I try to code the way you have mentioned eostic. The tag for eg <abc> is replaced as "<abc&gt:" in the output file. Actually "<" is replaced as "<" and ">" as ">" as markup value. Is there any way to solve this problem.

Hi All, I have searched all the post with this error but i could not find any post which is similar to that of mine. The following are the errors filtered from compilation error I got. ##E when checking composite operator: Subprocess command failed with exit status 256. ##E Could not check all opera...

Yes, i thought the way you have mentioned, but is there any simple way to solve this problem.

My job is designed as follows

Sequential File ----> Transformer ---------> XML Output Stage

Hi All, I face a problem in using xml output stage. I need the output as <member> <attname> FST_NAME </attname> <attvalue> Abu </attvalue> <atttype> 1 </atttype> <phone> P </phone> <attname> LST_NAME </attname> <attvalue> Mamar </attvalue> </member> But I get it as <member> <attname> FST_NAME LST_NA...

If ColumnA = 'dsx' Then
If Len(Trim(TARCOL1))=0 Then
If Len(Trim(TARCOL2))=0 Then TARCOL3
Else TARCOL2
Else TARCOL1
Else
<Condition if ColumnA<>"DSX">

I havent used this function like len(Trim) rather I have routine being used. So check if this is correct.

Your requirement is unclear. Anyhow I will give you a sample logic. Check if this is fine. If Col1 = "DSX" Then "DataStage" Else If Col1 = "DX" Then "Dstage" Else "Ascential" If you want exact solution then give the condition to get "Dstage"...