DSXchange

Craig,

Thanks for your response.

To make myself clear, should I change the function to the following

Call DSSetUserStatus("Arg1,Arg2")
Ans =(Arg1, Arg2)

I'm using Stage variables in Job-1 to call the function. How can I pass values to the 2 variables in this job?

Thanks
Yamini

Ray, Would it be possible to pass two variables using UserStatus? I followed the design, explained above, and prepared 2 jobs and 1 Sequence. Also, I created a customer routine to get the user status Call DSSetUserStatus(Arg1) Ans =Arg1 Job-1 --> passes an argument to the routine Job-2 --> selects d...

Friends, My new assignment requires me to extract data from 3 different tables present in 3 different schemas, in the source, to one staging table in the destination db. In other terms, the requirement is to select the data based on the VENDOR column (VENDOR=1) Check if the first table (in 1st schem...

Friends, Is there a way to pass variables during the run time to the ODBC stage? My current project requires me 1) To get a value from the log table and pass this to the next stage (ODBC.) 2) Use the above value in the WHERE clause of the 2nd ODBC stage to retrieve data from the source 1st ODBC(get ...

Friends,

Everyday some of our job sequences are failing with the following error

"Controller problem: Error calling DSRunJob(VENDOR_INFO_SEQ), code=-99
[General repository interface 'other error']"

Any idea why this would happen on a regular basis?

Thanks in advance
Yamini

No. From RHEL4 32-bit to RHEL5 32-bit

Friends,

Currently we have DataStage installed on a Linix server which is on a RHEL4 base. Our infrastructure team is planning to upgrade the server to RHEL5

Would there be any issues with DataStage if the server is upgraded?

Thanks
Yamini

Is 'Trim' the only solution available?

Ray,

Where can I set the parameter 'APT_STRING_PADCHAR'?

Thanks
Yamini

Craig,

I have tried that option as well. I modified the size of the columns to Char(30) but the job still fails with 'Inserted value too large, row rejected' error.

The job completes successfully if I a) Trim the columns or b) Increase the size of the columns in 'Transformer'

Thanks
Yamini

Friends, I'm having trouble with inserting data which has CHAR columns using DataStage. Due to new project requirements, most of the source columns are been changed to CHAR(XX CHAR) [Previously they were CHAR(XX BYTES)] The source table has 5 columns: 1) Merch_key --> NUMBER(10) 2) Merch_Name --> CH...

Friends, For the past couple of days, some of our DataStage jobs have been failing with the following warnings/errors 1) JobControl (@Job1): Controller problem: Error calling DSPrepareJob(RTL_MNG_INFO) (DSGetJobInfo) Failed to open RT_LOG125 file 2) Unable to allocate Type 30 descriptor, table is fu...

It worked after I made some changes. Apparently we cannot store commas in a numeric column in Oracle. I used convert function to strip the commas as well as '$'

It didn't work . I even tried removing the commas using Trim function

Craig, Sorry for the confusion. The following are the results of the latest execution Scenario 1 ) Columns in the destination table were defined as ' Numeric ' Result : All the input rows were rejected with " Non-numeric data was found where numeric required " error Scenario 2 ) Modified t...