DSXchange

Hi Pandeesh, try this option lets assume you are geeting input as | delimiter with 4 columns ex: Input Data A|B|C|D --> input row data Link your I/P to Transformer stage then define a stage variable to hold the 4 column values. svRow-->Colum1:"|":Column2:"|":Column3:"|"...

Please look into this https://www-304.ibm.com/support/docview ... wg21516610

Hi madsongtel, Please go through with the below link it will brief you about Out-of-band to normal representation and normal to Out-of-band representation: http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/index.jsp?topic=/com.ibm.swg.im.iis.ds.parjob.adref.doc/topics/r_deeadvrf_The_modify_Oper...

I tried by passing the full path name before dsjob command. Again getting same error..

Hi, Created a server job to get the job log details: It's working fine in v7.5.1 I/P: Seq file under that selected Filter Command dsjob -report project_name job_name XML While creating the same job in v8.0.1 I am getting the following error: Error in filter command Could you please guide me how to a...

Please use proper Subject name... I think its related to datastage versions :) Datasets from previous versions are read-only after upgrading WebSphere DataStage If you upgrade WebSphere DataStage to any other version, you cannot modify data sets that were produced before the upgrade. Parallel datase...

i achieved this already i am using this... 1) Create Server Job I/P Seq file I/P uvodbc.config --> Stg settings use [Stage Uses Filter commands] --> O/P tab in Seq Stg under Filter Command use the dsjob -report <proname> <jobname> XML 2)Map it to XMLInput Stage Split the columns arrordingly... Cheers

Chandra, Please search in the forum before raising any post, b'cause some of the solutions were already answered. All of you requirements will not get in a bunble. check the below link to get the job status codes http://www.dsxchange.com/viewtopic.php?t=118771&highlight= We can get the the log d...

pls check the below link:

http://www.ibm.com/developerworks/forum ... D=13829337
(or)
http://www.andykhan.com/jexcelapi/

Go to Director > Job > Cleanup Resources. Now the new window will be ready for you. Look into the bottom Locks and choose show all. Find your job will be waiting for you. Notedown the PID. Then choose show all radio button in Process. There you can find the same PID. Select it and Logout. OR ps -ef...

I want to delete all occurences....

Hi All, I need to delete all occurences of duplicates from Sequential File as Input... Input.txt RNO|NAME|GRP|AGE 1|S|10|52 2|X|10|52 3|Y|20|52 1|Z|10|52 4|A|30|52 My Desired Output should be: RNO|NAME|GRP|AGE 2|X|10|52 3|Y|20|52 4|A|30|52 I acheived using Shell Script & Loading into DB & by...