DSXchange

This is the source information STUDY PROJECT XX.F2100 PA.F2100ATT Xy.F2100 PE.F2100CRS AB.F2100 PS.F2100EXT CD.F2100 PD.F2100MSC (table data) Target should be loaded: STUDY PROJECT F2100 F2100ATT F2100 F2100CRS F2100 F2100EXT F2100 F2100MSC (table data) I know trim function but how to tell DS that o...

chulett wrote:It will execute once per node unless you run the stage in Sequential Mode. ...

Thank's for your help!! it worked thx Chulett !!

I am executing a stored procedure from DataStage stored procedure stage I am giving the following info in SYNTAX TAB Procedure name: PKG_CLID_REQUEST.PRC_MAIN Procedure Type: Transform Check box checked in for GENERATE procedure call The director log is below: main_program: APT configuration file: /...

chulett wrote:Already addressed that issue. Type it in yourself, do not copy/paste from the post that suggested it... as that "dash" and your dash are different characters. ...

hi craig

I got it u r really genius thanks for quick reply and help!!!!

chulett wrote: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. ...

Thanks chulett it is rejecting when I keep reject link from source file itself thanks for ur help

I have requirement to send a reject file as attanchment in email which is running fine. But when comes tio sending email it is sending in in-correct format. for example my reject file on unix box is correct format this format which is correct format US |2738101 |2063190 ONTARIO INC (JULIE SMETHURST)...

could you please provide sample record having junk characters as of now we dnt have junk characters in file working with sample data. in near future if we found any junk characters we should reject it but anyway asume these are the junk characters ‿‿‿‿×¢×¢ |PRO |sgahtsgsa |17500 |31/12/20|01/01...

It is working as expected. Good. ... haveing trouble when i use the constraints as above mentioned it is working but when in the source data has junk caharacter in the columns it is not rejecting to reject file it is loading to target which is should not do I am using constraint Trim(Src_Input_link...

So... in case it's still unclear what needs doing here... your final UNIX command that gets run after the two "halves" in the stage are put together need to look like one of these two: cd \The\Director\Where\TheFile\Lives && wc -m Reject_UK_VAT.txt -or- wc -m \The\Director\Where\T...

In the transformer stage, give the constraint to check for isNotnull() of all 7 columns.[ IsNotNull(col1) And ...IsNotNull(col7) ] . hi all, In transformer stage i gave consraint for output link: Trim(Src_Input_link.column1)<> '' And Trim(Src_Input_link.column2)<>'' And Trim(Src_Input_link.column3 ...

vinothkumar wrote:You need to reject recrods if there are no values and space in Src_Input_link.Address_Book_Number . If yes, for reject link use

Trim(Src_Input_link.Address_Book_Number)=''

Hey thanks ""Vinoth"" & ""DSXchange""is working fine thanks for ur input

vinothkumar wrote:Check Trim function

i need to reject records if it has space

Requirement is : Src_Seq_stage>> Trans _stage>>>sql servtgt Reject stage from Trans_stage In this scenario I am able to reject records to reject file and load remaining records to tgt table if there is no space in || column it is rejecting to reject file UK ||SUSAN MCCLUSKEY |c/o: FLEMING But in thi...

I have 1 rotuine which is working fine with below functionality The Routine will work only if the job contains 1 input and 1 output But I have a job which has reject link it is rejecting records to a file but job is getting aboted due to this reason UK_LOAD..AfterJob (fatal error from 1): The record...

hi all,I am new to datastage need some inputs my requirement is source seq-file satge>>transformstage>> sqlserver_tgt stage I have 7 columns in a row from source if any column in the row is null i have to reject the entire row could any one could suggest a way would help me new to datastage