DSXchange

We are using Informix as source database. Datastage 7.5 Enterprise supports Informix Enterprise,Informix Client,INformix Load. I need more understandinmg on these stages like which one is fast in performance wise. and is the performance same in server and in parallel?

We are using Informix as source database. Datastage 7.5 Enterprise supports Informix Enterprise,Informix Client,INformix Load. I need more understandinmg on these stages like which one is fast in performance wise. and is the performance same in server and in parallel?

Hi,
We have a problem in the Enterprise Edition of DataStage 7.5. The job is aborting if any of the length of column name in the Informix source stage is greater than 19. Are you aware of this bug? Is there any patch to fix the bug?

Thanks i am have written a small routine with Int. this is working fine.

This is what i need..

ROUNDUP(31415.00, -2) Rounds 31415 up to 2 decimal places to the left of the decimal ((31500)..This is MS excel function,i am converting this formula in Datastage. Is there any other function which works as above.

.I guess int() can give 31415 only for this example.

Hi,

Does anyone have a routine to ROUNDUP a number? I would appreciate your help.

Hi,

we are exported all the routines,stage type and table definitions as read only to new project. we want to make non-read only. I know there is a command to make non-read onlyfor jobs not for others(routines,table definitions). If you guys know the command to make it non-read only, please help me..

Just see how many nodes are in config file..Some times if you are using multi nodes and not partitioned well , you will get this mis matched rows..In developement, may be parallel jobs running on single node.so you didn't get this error..Just check it out in production environment. I am not sure how...

As per DataStageCnu, i am trying to convert FAT32 to NTFS to get installation.

thanks to all

hai

I was getting follwoing error while running the job. i used some user- defined sql in the table look up.i ran the same query in database,it was giving required results.but when i try to run through datastage job,it couldnot work.please help me guys. [ODBC 20101 driver]6033 SQLExtendedFetch: Error re...

Hai guys,
when i tried to look up with hash stage,i was getting some warnings like "Hashed_File_33.DSLink27: ds_uvput() - Write failed for record id '<Missing or NULL>'" though it ran. i dont know what could be the problem for this one. Can you help me guys.

problem is solved if i input the field like mm-dd-yyyy instead of yyyy-mm-dd.
thansk guys.

Could you provide the link of the forum if possible. i could not find..
thanks for your help

i am loading a table with flat file input which has date field. metadata for source file date field is same as table date field. but when i tried to load into table, date is getting null. it was warning like "Value treated as NULL Attempt to convert String value "2005-10-19" to Date t...