DSXchange

Hello, We changed that also and still we are getting the same problem. It works only when we use completely hard coded values for the update columns including the where clause. But when we pass the values from transformer stage into the Oracle stage, it is not working. All we do is update two varcha...

The table name and column are less than 20 characters in length.
We will try this APT_STRING_PAD_CHAR as parameter and let you know.
We tried to hard code value, used parameters and also NULL for the columns. But same issue.

There is no abort or warning. We saw 1480 code using peek.

Hi All, We are using DS EE 7.5. We have a parallel job where we are just doing an update on a varachar column. We are getting sqlcode -1480. Even though it has a not null value, still we are getting the same. Also I checked my environment variable APT_STRING_PAD_CHAR which is having 0x00. We used an...

Thanks a lot. it is fine now.

Hi Chulett,
I did re-indexing. but I am not able to see any jobs in DS Designer/Director/Manager. Is this an issue. Please help me in resolving this.

Regards

Hi Ray,
The value for T30FILE is 200 in the uvconfig file.

I am facing one more problem. When I try to do export, I am able to do only the whole project and not by individual categories. If I choose the option it throws error.

Is this also related to the T30 file?

Regards

Hi,
Where should I check for the T30FILE configuration parameter?
if in dshome, which file ?

Hi, Due to this problem, is there any chance that we may not be able to export the jobs also ? We are getting this message : Error calling subroutine: *DataStage*DSR_SELECT (Action=2); check DataStage is set up correctly in project castle (The connection is broken (81002)) We wanted to export the jo...

Thanks a lot. Will look into it and revert back.

Hi, We have DS installed on Unix(Solaris).I created a dsn (non-wired protocol) for oracle in DataStage Server 7.5.1a. I have done the configuration settings in .odbc.ini and uvodbc.config. Also made the changes required in the uvodbc.config Projects/<projectname>. I tested the connections and was ab...

Hi
We have DS7.5.1 installed on Unix. How can we use MS-Access as source?
Is there any option out to extract data directly from MS-Access db? Please suggest.

Regards
Ramesh

The source is a text file only which has 3 columns. One of the columns is to be populated to a clob datatype field in target. I will try the option of specifying contains terminators. Sorry for the delayed reply.

Hi, We have a requirement to read a text data which is running in paragraphs with newlines in between. The source is a sequential file. We have defined LongVarChar in DataStage to read this column as the target database will have CLOB datatype for this column. But still when I tried to view the reco...

Already it is in a sequential file. Even if I give mm/dd/yyyy without timestamp, it gives me overflow error. I am using ODBC for ORACLE.

Hi, I have a flat file input with a datetime column. The input data will have the format mm/dd/yyyy hh:mm:ss. The target is oracle database. When I tried to load data, I am getting the error Datetime field overflow. I have chosen timestamp as the datatype in DataStage and date in the target Odbc sta...