DSXchange

Hi, we have a empty Unix box and need to install Datastage V 8.7. I had a look into many IBM sites for the process to be followed but didnt get the info that I want (as a leyman). Can any one please let me know the steps to be followed for successfull installation. I am expecting info like 1. metada...

No one change any. Sorry

No change in schema. Also checked parameters and no issues seen.

There is a difference in SQL output between first 2 runs. First time it says as 30 records as output but when job ran again it throws 4 rows as output. Job design is odbc stage - > Transformer - > Seq File. couple of joins in the SQL. I am getting same results which I get in 2nd run if I run 10 time...

Able to see mismatch between live production code (unix server) and code in version controller (PVCS tool). There are times that version controller is not used promptly due to some issues and now creating problems when new code comes into Prod environment. Now trying to capture a process to identify...

Yes it is server job.
Small change in design. It is not seq file instead it is hashed file.

hash 1 & 2 -> Transformer->hash file

I have two files (Seq1 & seq2) and need to compare two file with column name policy. Seq File1 Policy_no Type Seq File2 Policy_no I am comparing both policy_no and if matched then type should be XX Else YY. I am doing this logic (col1=col2 then xx else yy) in transformer and defining the logic i...

No. It just split the file into 3 and combine again as 1 file.

I have done a complete search with the subject but not able to resolve my issue. Can any one help me with a solution I am facing fatal error with Link Partitioner stage. 2 Million records are processed every week but facing this issue today. Checked buffer size and timeout and showing as 1024 & ...

Sam,

No. Input file is a txt file. File has header and data as well.

We came closer now. As you mentioned if DSLink2.Record[1,1] = 'H' then DSLink2.Record[8,8] else DSLink2.Record My question starts here only, how can I define the column DSLink2.Record since this is a Header record. I can use as below if record type = H then ....... not sure how to define then statem...

Thanks but not clear for me. Can you more specific. I am not clear how to define the header record in transformer.. then how to cut the data from the header record and populate the value

Header record will look similar like

HIAgree20110414000000004

I need to take the batch rundate from the header record of the file and use it as a column vlaue in my job. ie Start date (column name in transformer) will be the run date in the transformer stage Job design will be Seq file -> Transformer->Dataset Header record will be XXXXXXX20110414XXXXXXXXXX. He...

No varchar fields, only char & numerical fields and lengh defined.

I am getting error as below when trying to view the input data in Seq file. Please advice to resolve the issue. ##I IIS-DSEE-TFCN-00006 13:59:46(001) <main_program> conductor uname: -s=AIX; -r=3; -v=5; -n=p23109dev394; -m=00CF15C44C00 ##I IIS-DSEE-TOSH-00002 13:59:46(002) <main_program> orchgeneral:...