DSXchange

I did used share point in my project through webservice stage. Share point team has provided the wsdl

xml

xml

xml

Processing Type: Parse The administrativearea_qsav is inconsistent. The matchscore AdministrativeAreaMatchScore_QSAV for both are 100 But AdministrativeAreaStatus_QSAV is 6 for one and 8 for another. For both the accuracy code is U00-I44-P2-100 I gave one Colorado address and other Illinois address....

I could able to achieve it. Just did trial and error methods and could able to get it after like 20 trials. Maybe I didn't got it in first place as my dsxchange account expired and I renewed just for this to see if I can get help immediately. bummer.. need to be more patience from next time before r...

I absolutely have no clue on how to achieve this. So basically I am looking for a detail explanation.

The design I gave is the test I am doing currently, I am passing the value manually at runtime using job parameters but in actual scenario I get those values from the input.

The parameters do come from input. This Stored Procedure will be in middle of the job. Should I need to use Generate Procedure Call. So on the input tab, the columns should be only two (Parm, Input) - I/O Type Input On the output tab, should all the in and out type columns present. There are also tw...

My job design would be Stored Procedure Stage ---------> DataSet I am using stored procedure transform type, import all the parameters and column mapping has to be done based on what you said, is that right? What about the default proccode and procmess fields created, should I map them to any fields...

I have searched a lot and tried few trial and error methods with stored procedure stage but not able to be success in calling a DB2 Stored Procedure I have 12 parameters, one Input, One Input/Output and 10 Output types. Like; Column_Names|SQL_Type|I/O Type|Length PARM|Char|IN|23 MSG|Char|OUT|193 INP...

Recently I had an issue with using Cat command in datastage which triggered me this question. Our datastage server is installed on Linux. We can use unix commands in command stage right? Does it work exactly as commands written on Unix box. We can only write one line commands, right? The below infor...

Thank you!

Found a similar post in DSxchange. Initially my search didn't pull any as subject is not appropriate for the other post.

If someone opens this message, here is the solution link.

Need help with code Source Data code address a1 xyz a1 abc b1 a23 b1 xmn b1 dkl c1 lmo a2 pqs a2 sfo d1 dnm d1 knm d1 gnm Required Output code address a1 xyz abc b1 a23 xmn dkl c1 lmo a2 pqs sfp d1 dnm knm gnm The number of times the code may repeat is unknown. So need to pivot based on the no. of t...

Can you explain more on how to write the code?

Is it feasible to use routine to achieve the same.

If I have to find the value used in job then how is it done differently

Your question put me in confusion but I think I need

Value Used at runtime