DSXchange

Hi,
Say suppose you have 2 links A and B.
On Link A you gave some constraint.
On Link B , give a constraint as Link A.rejected.
This will pass all the records failed from A to B without any warnings.

IHTH,

Phani

Hi,
Check whether source file you are using is under Data directory in your project folder.
The DatafileDefinition and the Source file name should be the same.


Thanks,
Phani

HI , You can use Ereplace function Ereplace(ColumnNAme,char(13),'') This replaces the Enter Char( char(13) ) with the empty space. You can also Use OConv(ColumnName,"MCP"). This argument converts the non printable characters to a " . " . Again replace the " . " with wha...

In the format tab of Sequential File in Input tab , select the check box against " First Line is Column Names " and run the job.

HTH

Hi, We can clear the column derivations one by one if the columns are less in number. The approach I follow is ODBC --------TFM -------- SEQ Put a sequential file Stage as target. Open the tranformer stage. Move all the columns form source stage to target. Delete the columns from the source. Again m...

Thanks Ray,

Now it is working.


regards
Phani

Hi, Please find my code below. Deffun DSRMessage(A1, A2, A3) Calling "*DataStage*DSR_MESSAGE" HashTable = Arg4:Arg1 HashKey = Arg2:@TM:Arg5 ColumnPosition = Arg3 PositionReturn = 0 * Determine if we are returning one column or entire row. If Num(ColumnPosition) then ColumnPosition = Int(Co...

Hi,
You can use Oconv function like

OConv(Arg1,"MCN") which extracts only the numeric data from the argument passed.


cheers
Phani

Hi, Its not a good practice for calling the Transform in a routine . Instead you can call the routine with in the routine. Declare the DataTypePicComp3 routine ( since the tranform is calling this routine in the transform) using the "Deffun" statement and call the routine Var = DataTypepic...

hI,
I modified in my routine as required.
I am using a two key hash file.
I am getting output as Record not Found.

I had used the
HashKey = Arg3:@TM:Arg5

where Arg3 and Arg5 are key columns data.
The routine is working fine with one argument.

Please help.

Regards
Phani

Hi,
Currently I am working on version 7 and that option is available.

Cheers
Phani

Hi,
Open the Administrator Client.
You have two Tabs.
General and Projects.
Go to Projects tab. Select your project name.
On the right side you will find the Clean Up button.
Click that Button.

HTH,

Phani

Hi,
I want to delete a sequential file using the datastage job.How to delete it.

Thanks

You can find the difference by using Iconv and OConv Functions in datastage.Please go through the help for the same.

Hi
We can use the KeyMgtGetNexValConcurrent routine which is present in datastage for generating the sequence numbers using Datastage.Tyr this routine

Hope this Helps
Phani