DSXchange

Craig,
Thanks for your reply!
Yes, these are still server jobs in DS 8.1 Enterprise Edition. Yes, target OCI stage has 8 column mapped from XFM stage. Executing user has proper grant to the sequence object as well.

Hi, We have migrated server jobs which were in DS 7.5.2 to DS 8.1 parallel version. Both of these versions installed on same Linux server. Some of the DS server jobs with OCI stage has user defined SQL. These SQLs first column is the oracle sequence next val for surrogate key and the remainder colum...

I used ODBC ---> ODBC stage for CLOB xfer

chulett - Thats exactly what I am looking for a new function which would do what the DIGITS does. But I dont know how to go about it. Writing a C program for this would be a too much to ask. There has to be a simpler way to check for numbers. Ray. I am not sure how to read the data in Hex format in ...

But I dont know what I am converting from. It looks like a space but it is not a space.

I tried TRIM on the database, and Datastage but it does not goaway.

Please let us know how it got resolved.

Thanks
Sarju Shah

I was receiving the exact same error today in my job. Check if you handled all your nulls.

Once I took care of some nulls the error got away.

Best of luck

Sarju Shah

We have data on a Teradata table and it contains Numbers followed by some thing (seriously something.. not space..not tab ..not sure what). Trim while selecting the data or Trim / StripWhitespace in datastage wont get rid of it. It was loaded from mainframe.. so may be someone goofed up. Thats not m...

Thanks.

I will mark it as resolved.

I am trying to use built in transforms in the transformer stage on Version 8.1 Parallel Job and keep getting the error variable not defined. I tried using different transforms to see if other works and the erorr is the same. DataTypeEbcdicPic9 --> Link DSLink40, Column NewColumnTest: DataTypeEbcdicP...

Let me check with IBM. I will post what I find.
We pay them a boat load each year for support . got to use it sometime

Thanks

Hi Ray, can you please expand a little bit on your answer.

I have a 7.5.2 install on a linux box, Do I need to do something special during the install if I want to run ver 8 on the same server without uninstalling ver 7.5

Thanks

[quote="chulett"]Try getting rid of the last semi-colon.[/quote]

I tried that. But getting the same error TEMP_TABLE_OCI: ORA-00911: invalid character

I crearted this script which runs fine from SQL Navigator.But When I use it under User Defined DDL, I am getting a runtime error. The error is TEMP_TABLE_OCI: ORA-00911: invalid character How can I make it work ? here is rthe script I am using CREATE TABLE SCT003_CASE_BNFT_TEMP ( GRP_CASE_ID DECIMAL...

I Created it using the hash file stage. But I did not see that option to make it multivalued, and I thought that was ok as per Ken's post , but he made a mentioned about later updating the dictionary. As you mentioned in your post about using the ED command for updating the dictionary, a sample woul...