DSXchange

When read as char, the error is: Char - DSBrowser..SYBASEOC_1: Sybase data type 'CS_BINARY_TYPE' for column 'timestamp' is not supported SQL statement: SELECT retlr_loc_id,owner_grp_id,owner_grp_ref_id,owner_grp_ref_effctv_date,owner_grp_ref_exp_date,timestamp FROM dbo.OWNER_GROUP_REFERENCE DSBrowse...

Hi there, How is a column with data type TIMESTAMP in Sybase can be read with Datastage? No matter what type in Datastage table column is used, if it is Bigint, or Binary, or Decimal, it can be got to read. The error is as the following. Bigint - DSBrowser..SYBASEOC_1: SQL data type 'BigInt' defined...

I try Ray's method, and it works very well.

Thanks all your guys!

Hi there, When I have a chance to reexamine the result, it seems sorted orderly, but in a different way. The key's type is SQL Integer, but it is sorted as string. The result is as the following. How can hashed file be sorted as Integer (coresponding to its key data type, not as string)? Result: 1 1...

Your guys are right, thanks.

I recompile the job and get it the right status.

Even we recycle the Datastage server, the job is still running!

Hi there, When a Datastage job call a Unix script to do a DB backup, the backup process hangs up. When the backup process is killed, the job is still running. We try to stop it, but it keeps running. This process keeps trying, but just cannot stop the job. Even we use the Director Clear Resource to ...

Thanks, that's a good idea.

I write a routine as the following:

If IsNull(Arg1) Then
Ans = ''
End
Else
Ans = Arg1
End

When it is tested with the Arg1 = @Null, the result is @Null. Is the Datastage Code Test does not identify @NULL?

Thanks,

Thanks everybody, I see the CRC32 function in Datastage. There is another question: the concatenate operation ':'. When two strings concatenate, the result is null if any one is null. This causes problem. Is any opeartion there in Datastage that returns non null result if any of the two is not null....

Hi there, The cyclic redundancy checksum (CRC) can be useed to determine quickly if two complex records from source and target separately are the same or not. If they have the same CRC, then they can be treated as unchanged since last update. If the two CRCs are different, a new record is added to t...

Yeah, I save the metadata and load it into in the same Hashed file stage. There are only two columns in the file. There is no chance to make mistake. There is no "dictionary" listing anyplace in the stage.

Thanks,

Hi Michael,

The target file is a sequence file. I run the job, and view from the file. It is not sorted.

All three are run from Director and get almost same error messages as I posted.

I try

@ID = @ID BY @ID.

too. But it is the same: not sorted in output file.

Thanks,

I try all above suggestions as the following, but not one works: First: SELECT H_RetDevLoc WITH 1 = 1 BY @ID Error: LoadLotWagerCancelTActivity..H_cLookup.DSLink21: DSD.UVOpen Retrieve: syntax error. Unexpected explicit item id. Token was "1". Scanned command was SELECT H_RetDevLoc WITH '1...

Thanks, I do not understand "You can add either BY {fieldname} to sort in ascending order or BY.DSND {fieldname} to sort in descending order. " Add "BY {fieldname}" to where? To the "Hashed File" stage, or in the BASIC CODE? Is it possible to use the "Hashed File&q...

Hi there,

Can a hashed file be read from in the sorted (key) order and How (Not in BASIC CODE, but from the visual stage "Hashed File")?

Or can SSELECT command be used in the "Hashed File" Stage to read contents from it in the sorted order?

Thanks,