DSXchange

Shrinivas,

Instead of CHAR(10):CHAR(13) use and try CHAR(13):CHAR(10).


Thanks,
Anupam

Its a control Routine where I am writng the status of jobs in the sequential file .The routine fetch the starttime and status of all jobs in my project. All status stored in a single variable with deimeter ";". but when i write in to sequntial file I want them in to diffrent lines as I me...

i am writing to a hash file first and in the second transformer i read from it for a lookup. I dont have any caching enabled for the hashfile. Will this work? will all the records be written successfully before the read operation begins? ANY HELP IS APPRECIATED. ---------- ------- ------- ---------...

Hi,

Are you using delete/create hashed file option while creating lookup some time this wont work. Better to go with clear hash file and then loads option

Thank You,
Anupam

Hi,

Use DSTranslateCode() function....................


____________________________________________________________
Anupam

Hi,

You can use ODBC stage to call store procedure.

In ODBC stage import --> store procedure defination - >Provide arguments.

In ODBC parameter tab provide value or parameter in value section...



Thanks,
Anupam

Hi,


Create parameter for database schema... Like

SELECT FIELD1, FIELD2 FROM #SchemaName#.TABLE_NAME;


Thanks,
Anupam

Hi, 1. Order by key column. 2. Store value in variable and compare old and new key values if equal then double file else normal insert in target. Ex: Arrange varaiable in following order Var = Key Var1 = If Var = Var2 Then "Cons Double File" Esle "Cons Insert Target" Var2 = Key T...

Look like empty string... Try to add Trim(ColumnName) <> ''...

Thanks,
Anupam

Parag, If data is huge we cant work with this. Better to create two jobs First jobs reads distinct of material code from file (use aggregator to get distinct) pass this value as parameter to second job use DSRunjob routine to trigger second job in first job transformer. But need to think of performa...

Try now

If i/p_column1 = "A" AND Not(IsNull(ip_column2)) THEN
ip_column2[1,7] ELSE @NULL


Thnaks,
Anupam

vij wrote:
If i/p_column1 = "A" Then IF IsNotNull((ip_column2)[1,7]) THEN
ip_column2[1,7] ELSE SetNull() Else SetNull()

Why not AND in condition ..... like

If i/p_column1 = "A" AND IsNotNull((ip_column2)[1,7]) THEN
ip_column2[1,7] ELSE SetNull()

Thanks,
Anupam

Hi,


It is possible to divide file into multiple file with combination aggregator stage and folder stage....


Thanks,
Anupam

Ray,

Yes it takes only single charcter.....

Thanks,
Anupam

Please inspect your result file with a hex editor, or Oconv(String,"MX0C"), and show us that the Char(10) characters have gone. After all, it's not a printable character. ... Yes, It is also working without Char(10) also... Field(Column2,Char(13), 1) But Field function allows more than si...