DSXchange

thanks!

I've another question. What the range of decimal number DataStage can handle? i find the we get the wrong result when the decimal number bigger then 10digits.

a little change! the 21digits can cut down to 19digits.

Can datastage do thirty decimal? If ok , i will divided the 21digis string to two parts ---- one 10digits, another 9digits , thirty decimal them separately, then compile the two results. It would be bad performance i think

Thanks Ogmios and Ray for helping Unfortunately the customer insists that the source and target table can not change. The further information is that the 13digitals field is only for a primary key to distinct records(to distinct these 21digits strings more exact, cause they have some other tables co...

Hi, I have a key filed storing 21 digital number in source table, the target table key field only can store 13 digits in length. How can i convert the string length from 21 to 13 or less ,keep uniquely? it's out of range when converting the decimal number to hexdecimal. can i use CRC32 function? Is ...

The meta data for input and output links is the same.

Ray, thanks for your reply As what you said, I got the output error of SQLError () function --"The DataDirect ODBC driver you are attempting to access has been provided to you by AscentialSoftware for exclusive use with DataStage. You are not licensed to use this driver with any application oth...

I have two set of system each one with Informix db and ds 6 on HP UNIX. I can run job extracting/loading data from/to Informix database using ODBC/informix_cli stage on both machine, but when I test a sql-routine (the sql is very simple just like "select...."), I found all is ok until SQLE...

The case as follows: 1. A master input file, based on the business rules, it may or may not generate a master reject file which failed on the business rules checking. 2. Then if master record rejected, all the related child records should reject. 3. Therefore, I need to perform a lookup for Child re...

Hi all,

I am going to perform a lookup from a lookup dataset, the dataset may or may not be blank (without record). If the dataset is empty, when processing, error come out? Anyway I can merge / lookup / join a blank lookup file?

Thanks!