DSXchange

Sure. In my parallel job, I have an input ODBC stage 'odbc_DBO_COGNOSBUDGETS' which reads rows from a table on an SQL server and goes to a Transformer stage called 'xfm_BUDGETS'. In the below messages, 'ID' is obviously a column. Here are the error messages: Warning (type): odbc_DBO_COGNOSBUDGETS: W...

If you mean setting $OSH_PRINT_SCHEMAS to 'True', then yes and the error message tells me the name of the column (there are 5) and just used 'AAA' as an example name.

I'm going to go ahead and continue this thread as well. I'm getting the same error on a table coming from an sql server. I'm using an ODBC Connector stage to connect to the table and have loaded the table definition and can in fact see the columns and table data when I select 'view data'. The column...

For each job that we run, we want to first collect the number of rows on the table, then after running the job, the number of rows now on the table. Also, we'd compare these and if there's a sufficient difference we plan to send an email so the ETL developers are notified. So, here's my question. Wh...

Just wanted to add some information here in case it's useful to anyone else. We were getting the same error, and discovered (in our case) that the ASBNode service will refuse to start a listener on TCP port 31531 if you have the following empty config files in place: /path/to/datastage/ASBNode/conf/...

Ray, Thank you for that confirmation. We had initially used $PROJDEF in our jobs, then moved to parameter sets in the hope of saving time, but found that we had to recompile the job each time we migrate the jobs into our production project. With $PROJDEF working for jobs that are migrating across pr...

Thanks for the tip, Ray. I've got the Data Connection set up, but what I'm really hoping to do is use Data Connection in two different projects (Test and Production) with the test Data Connection point to Test and the production Data Connection pointing to Production. Currently, I've got the two dif...

Hello, We just converted from 7.5 to 8.7, and have noticed that when we import table definitions using the Oracle Connector Import Wizard, it is changing Char columns to NChar and VarChar2 to NVarChar. I have found references to this in previous posts and within the DataStage documentation, but I am...

Here's a follow-up question. I'm attempting to use some of our user defined Environmental Variables in a 'new' parameter set to attach to a Data Connection (Oracle Connector). I have been able to include the Environment Variables with no problem in other parameter sets that I've created. However, Da...

Hi all, We've recently migrated from 7.5 to 8.7 and shortly will go to 9.1 Enterprise Edition to make use of parallel jobs. Currently, we're connecting with environmental variables that are grouped in parameter sets. We're considering the Data Connection option though. Will the Data Connection provi...

thanks again Ray but the data was not loaded into the table.

Thank you for your reply. The data type is VARCHAR2 if we use wire driver and NVARCHAR2 with nowire driver. We have tried LONGNVARCHAR and it gave a metadata mismatch error plus an 'invalid precision value' error. Try using Long VarChar as the data type in your metadata. What is the data type when y...