DSXchange

That being the issue if the database is DB2 wherin there being logs generated with truncate.....
so to truncate we need the command in DB2 as
TRUNCATE TABLE TABLE_NAME
DROP STORAGE

Probably please check the database and then we need to find out wats required to do.

7.5.1a value = 0.18 8.1 value = 0.17999999999999999 These variation in the value...... There being two fields in the metadata definition of the column one being length and the other being display. Put the display as 2 more than the length. The more here reflects one for the precision and the other b...

create the header file in one sequential file seperately. then get the detail files as per yours requirement. Then use shell script as after job subroutine to append the detail files to the header file. I hope this would work fine as per yours requirement. To append the header and detail files you m...

ues the function NullToEmpty in yours transformer dataset will treat blanks as null

Use Transformer and in its derivation for column use the way you want the output to be------ "Case No=":COL1:"|":"Case No=":COL2:"|":"Case No=":COL3:"|": ................................:"Case No=":COL300" This way you have 3...

in the transformer derrivation you have a function @NULL
Please use that in place of SetNull()

Let us know if that works

the ini file is not a feature of DataStage. You are probably running the DS Job from Unix command laine and passing the parameter as the name of the ini file. All you need to take care is that you add/overwrite the new parameters you want in the .ini file and then further when you run the datastage ...

In transformer use the derivation as......

If IsNull(%inputcol%) Then SetNull(%inputcol%) Else ''

select a.fld1,fld2,fld3 from TableA a where not exists (select b.fld1,fld2,fld3 from TableB b where b.fld1=a.fld1 and b.fld2=a.fld2 ) For large number of records as like in Datawarehouses it is advised to create staging table containing only the key fields and then perform yours SQL query on that an...

Check the input table for the ODBC stage if any data has been updated in the second run.
If not please provide me with the stages you are using and also where ISNull() function is used.

Probably you have to apply the function NullToEmpty function only on Null values.... so check if the value is null then apply NullToEmpty

So yours derrivation for the input should be .....

If IsNull(%inputcol%) Then NullToEmpty(%inputcol%) Else ''

Adding copy stage and getting two links out of that being appropriate here as mentioned by kris007 and also you need to replace hash file stage by a data set if you want to use the same data again as data dictionary, else you can directly pull up the link from the aggregator to the lookup stage. Tha...

I would recoment you to convert the delimiter in the source file "," (comma) into another delimiter "|" before processing it into sequential stage. If the character "|" is also used in the source file you may rather use some other characters such as ~(tilde) or $(dollar...

You will have to put JobA within another Job Sequence and then use the looping logic with Counter value set to the ParamA value. That way, JobA will run as many times you want with the correct instance ID's. Hope that helps. It would be better in this situation to run the job in multiple sequence u...