DSXchange

Does any one know what standard does Datastage 7.5 Checksum() function will return value ? I need use Checksum() function in my project, but some time it get CRC CCITT value, some time it didn't. I'm sure DS Checksum() should standard on one standard, either CRC 16, CRC 32 or CRC CCITT, but it looks...

Does the executing user have INSERT privilege to that table? Please post any error message that has been reported. ... Yes, here are error Statement was:{call TEST_DB.dbo.proc_AIP_Get_PeriodicAverageRates} SQLSTATE=37000, DBMS.CODE=1934 [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driv...

Does anyone have expereience to use ODBC stage to call stored procedure on Datastage 7.5 Server job ? It's looks like my stored procedure call to SQL Server 2005 database can't insert data to SQL table?

One cannot convert from one CRC result to another, the algorithms don't work that way. You could either program your own CRC-16 in BASIC or use a UNIX level CRC-16 program and call that from your job for each value to be computed. Good suggestion, I think write a CRC-16 program is good option, but ...

What, I wonder, do they mean by "standard". The Wikipedia entry for CRC shows six (presumably different) CRC-16 algorithms. ... Yes, checksum can have different value by diferent standard, Datastage 7.5's checksum get CRC-CCITT value, but our application need CRC-16 value. I'm wondering i...

Why should every checksum function generate the same value? There's no single industry-standard algorithm out there. Checksum can do whatever its author likes, as it doesn't need to be reversible, o ... The problem is, our syatem will only accept CRC-16 standard checksum, but Datastge will generate...

Can you calculate checksum for Payment_Data.PaymentNumber alone in both and compare. The problem is DS Checksum('1,,,,,,,,,,') will get value 11545, but other checksum methods will get 51547, which mean DS Checksum() return different value with other standard checksum calculation. I don't know why ...

Does anybody has experience to use Checksum() function on datastage 7.5 to calculatie checksum for string ? I use this format Checksum( Payment_Data.PaymentNumber:',':Payment_Data.VendorAccountName:',,,,':Payment_Data.VendorBankAccountNumber:',,,,,') to calculate checksum and the value is different ...

Hi, I am using datastage 7.5 Server ODBC satge to call a SQL Server 2005 stored procedure, and get following error : SQLSTATE=37000, DBMS.CODE=1934 [DataStage][SQL Client][ODBC][DataDirect][ODBC SQL Server Driver][SQL Server]INSERT failed because the following SET options have incorrect settings: 'C...

Does any one know how to convert date from "03-NOV-2008" to "2008-11-03"(yyyy-mm-dd) on Dastage 7.5 ? Thanks !

Hmmm... while that works in the Sequential File stage, you may just need to leave it blank in the FTP stage. ... Craig, Do you have any experience with such process on Datastage 7.5 : I need check if flat file has empty records, if empty , no ftp sending, otherwise ftp send file to remote server. W...

Make sure you tell it not to add anything to the file - quotes in particular. ... Right, I tries put 000 for delimiter and quote which mean nothing, but FTP stage abroted with error "not valid delimiter and quote". is there way to get out of this ? I solve this by set "no line termin...

chulett wrote:Make sure you tell it not to add anything to the file - quotes in particular. ...

Right, I tries put 000 for delimiter and quote which mean nothing, but FTP stage abroted with error "not valid delimiter and quote". is there way to get out of this ?

DSguru2B wrote:Did you try doing the transfer as a single column within the ftp stage? ...

Good ideal, I'll try this. thanks !

anbu wrote:Use aggregator and do count on any non-nullable field to get the row count

This did solve my problem. Thanks !