DSXchange

Hi all,

I want to develop a routine which Should result me with all job names and its relevant elapse time into a Excel File as Notification after completing Production run.

Please provide be some ideas.

Thanks

Hi, My input is having two fields one is id and another one is Name like below ID NAME 10 EDWARD'S CASH 20 RANJAN & RAJ 30 ROBERT BELL I am using xml output stage to create chunk and capturing output in sequential file and output looks like below <ServiceRequest><ID>10</ID><NAME>EDWARD&apos;...

Hi all, I have the below code in datastage. errCode = DSSetParam(instanceHandle, "New Parameter Name", New Parameter Value) If (errCode <> DSJE.NOERROR) Then msg = DSMakeMsg("DSTAGE_JSG_M_0002\Error calling DSSetParam(%1), code=%2[E]", "WriteMode":@FM:errCode) msgId = j...

please provide exact logic.

Hi all,

My Input
-------
Jun Fujimoto/Singapore/IBM@IBMSG

output should be in (trim ,upper case and removal of the last characters after @) like

Output
-------

JUNFUJIMOTO/SINGAPORE/IBM

please provide the logic for this conversion.

Thanks

Andy,

My input record like below:

Col1
a
b
c
d


each record come in next line not in the same line.

Hi Andy,

how to stri out the correct portion using field function please help me on this.

Thanks a lot Andy... I will try this and let you know any problems...

working on 9.1 version and there is no limit has been given by business for the number of records

There are no other columns only two columns we will get from source but output should be one column but two different records 1 for first column and second one for second column

Hi,

My source is like below:
Col1 Col2
a b
c d
e f
g h

Output should be like below:
Column
a|c|e|g
b|d|f|h

Help me on this please.

Hi All,

I have a sequence with Three Jobs inside it. all jobs are NOT dependent and running in parallel. If the sequence is re-started when any job fails,then all the jobs are starting from the beginning.

Can any one advice a solution on this issue.


Thanks

Hi Vivek,

Can you please elaborate your answer.

I am also facing the same problem.

My Source is 16 digit and I want to load into target with 16,8
Example:
Source: 1234567890123456
Output: 12345678.90123456

Thanks,
Skp

Hi Chulett,

Yes you are correct if my source record is coming as 'abcdefgh' and my reference record is 'abcdefg' Then i will get percentage of match is 90%. If percentage is having >= 90% then only I need to pass that record to target. How to achieve this in datastage.

Thanks,
SKP.

We will get one column "name" from source and the same column is also exist in reference table I have to check the percentage of match if it exceeds 90% then only I will process that record to target. I am not aware of Quality stage. The above mentioned is my requirement. Please let me kno...