DSXchange

hi
Need some condition in transformer stage to reject the rows if "|" are less than 5 so that i can reject that row?

Yes. In PX it would be directly from the stage, source or target, not off the Transformer like you would do in the Server product. ... in seq_file _stage i gave this format Record level: Final delimeter =none Record delimeter = Unix new line Field defaults: Delimeter =| Quote = none reject mode=out...

hi Ravi thanks for reply but need some help! in seq_file _stage i gave this format Record level: Final delimeter =none Record delimeter = Unix new line Field defaults: Delimeter =| Quote = none job is running fine but problem when testing it with reject logic not able to get reject records:(:(:( but...

i kept a reject link from source seq_file stage and Reject mode= output than also it is not rejecting the records to reject link it should reject in the below scenario mentioned if the coulmn does not have |before it reject it.. SHARPUK |ECS |EC goods imported into UK |0 |31/12/20|28/01/98| SHARPUK ...

ray.wurlod wrote:Use a reject link from the Sequential File stage that reads this file. Rows will be rejected if they don't contain the correct number of field delimiter characters. ...

You mean keep a reject link from sequential file were I read the data?
no need for trnsformer stage?

SUK |ECS |EC goods imported into UK |0 |31/12/20|28/01/98| SUK |OTS |Outside The Scope 0% |0 |31/12/20|04/02/98| SUK |PRO |Irrecoverable VAT pro-forma |17500 |31/12/20|01/01/06| SUK |RVC |Reverse Charge-Int'l Service |0 |31/12/20|01/04/91| SUK |UKB |Tax 17.5% |17500 |31/12/09|01/12/08| SUK |UKB |Tax...

wc -m Reject_UK_VAT.txt i am executing from putty it is returning value 8 as file size which is correct but how to implement in datastage execute command?
what should i give in trigger to send mail if file size is >0?

Reject file size is >0 in execute command i am giveing the path of the reject file were it is existing and then the command wc -w Reject_UK_VAT.txt and trigger as Convert(@FM,"", Execute_Command_42.$CommandOutput) > 0 it is no giving me exact results? please correct me if I am wrong?

Hi I need some inputs. My requirement: I have 3 requirements which are running fine. 1st UNIX script- Running as expected 2nd job loads the data into sql server table- Running as expected (with reject logic in transformer stage) 3rd job load the status of the job in audit table which is in oracle db...

Ok thanks chulett u rock :):)

hey chutlet... I tried this Convert(@FM,"", EX_SH_test.$CommandOutput) <> 1 now it is working fine but can you expalin about this functionality. I got the result but not able to understand the logic.Could you explain so that every body who reads this post can understand. Thanks for your he...

You need to remove the Field Mark(s) that they return with: Convert(@FM,"",custom EX_SH_test.$CommandOutput) <> 1 ... I tried two things 1)Convert("1",EX_SH_test.$CommandOutput) <> 1 it is saying genral synatx error. 2)Convert(@,"", EX_SH_test.$CommandOutput) <> 1 warn...

sorry @ArndW i am new to forum... this is the meesage I am getting in director log MAIN_SEQ_VAT_UK_LOAD..JobControl (@EX_SH_test): Executed: /local/apps/Datastage/projects/xxx_xxxx_xxx/Scripts/test.ksh Reply=0 Output from command ====> 1 in the execute command I am doing like this correct me if I am...

Hi all, My requirement is first write aunix shell script which checks if stop.txt file exists on remote machine or not. If stop.txt file exists my unix returns a integer value 1. Other wise it will run the rest of the script and returns integer value 0. Unix script is running fine but problem with d...