DSXchange

Hi all,
I have to treat with financial data, decimal field with many digits after comma.
What is better data type I can use for among float, double(dfloat) and decimal?
I don't understand difference between float-dfloat and decimal.
Thanks in advance.

Hi all,
I contacted directly IBM certification assistance.
Try It Again Voucher can be used for datastage cert, selecting Info Mgmt from Prometric site.
So if you failed first exam, you have second chance.

Not exists sample test for 8.5.....

Hi all, I hope this is right place to ask question about certification. First question, what can I study to take 8.5 certification? Second question, is it possibile to use voucher TIA with datastage? In this site: http://www.prometric.com/ibm/tiad.htm there is a list of product: Cognos - $230.00 Inf...

Hi all, I hope to find some solution to my question.... I load data into Oracle table using sqlloader; my source is a sybase table. Some fields are empty strings or contain one blank and are not null, yet in target table these fields are not null. When I use sqlloader, empty string and blank value b...

OK, thanks.

I used the odbc stage with write option, and in this case the use of square brackets gives error.
By using the upsert option within odbc stage, now table with square brackets is properly recognized.
Thanks

Hi All, I have a sqlserve table, whose name is like "Vers-xxx_yyy". As you can see, there is a character "-". I don't know why this table was made so But, I have to load it from datastage job. So when I run my job, I obtain error "table doesn't exist". I use odbc stage....

Hi all and thanks in advance. I'm developing a parallel job that has to invoke a sqlserver procedure. So I use Stored Procedure stage, but I have some problem. Design of my job is: column_generator->transformer->stored_procedure. In column generator i create one row to create a stream. In transforme...

Thanks for your replay. This is a link where I found notices about limits reading sybase fields of type float: http://publib.boulder.ibm.com/infocenter/iisinfsv/v8r5/topic/com.ibm.swg.im.iis.conn.sybase.doc/topics/t_csybref_Sybase_SQL_Server_Data_Type_Support.html I found a workaround: instead of tr...

Hi all, Using DS8.1, Sybase like source and SqlServer like target I encountered a rounding problem reading float field. In example, I read a float field with value 0.95, that become 0.949999.... In reference guide there is a note about this behavior, but is there workaround to solve it!? Thank you v...

Hi, I have a problem with the rounding of floating point numbers. I read numbers from a file, such as 0.0000295710, 24861.19, and 116342.61, which transformer converts into a numeric type. I simply map field from varchar to float/double, without using any function. The problem is that if I use float...

Hi all,
this is an update.
My local and remote support studied the case, and so they found two problem:
A) Client hardware configuration is undersized....only 2 GB RAM
B) Strange behavior in comunication between Windows Client and Sun Solaris Server with that particular job....

That's all.
Thank you

Hi all, I know that this topic may be off topic, however I hope to find an answer or a suggestion. I'm writing some shell scripts that launch job with dsjob and do some other things like collect job log (with dsjob -jobdetails ....), and load them on DB. So, these scripts call other sub scripts that...

Hi all,
in DS 7.5 exists RTI to create and deploy services.
In DS 8.1?
Thanks in advance

Yes, indeed I will do so.
I will update when technical support will give me response.
Thank you