DSXchange

Hi, I am trying to read all the fields from a flat file to a DB2 table. I have to read a decimal field from the flat file, but when I read it as Decimal, then all the rows where the value is null/blank are getting dropped while reading the file. Because of this, I am reading all the fileds as varcha...

// Generated file to implement the C96V96S2_repos_cnt_DI_Stat_6_xfrm_DI_Stats_1 transform operator.

Is the line on the other side.

I am sorry, I skipped the first 15 lines of the result to ignore the differneces in server name and modification date.

Thanks

I need to commpare the dsx files in two different environment to check whether there is any difference beween the two jobs. In most cases, I am getting the difference only on one line which shows up in the transformer script as below - // Generated file to implement the C76C78C80C82C86C88C90C92C96V9...

We have got a table with one of the columns prefixed with a number.
we want to use that column name in the DB2 stage using a schema file.
But every we do an import the designer throws an error that a column name cannot be prefixed with the a numerical digit.

Is a work around possible ?

Check if somebody in your team has got the director open and the current focus is on the said job(i.e if the said is job selected in the director at the moment).

If yes pls remove the focus and try again

We are using the same user for any scheduling or unscheduling purposes i.e. dsadm I am sure username is not at all a problem. Moreover it has nothing to do with viewing of schedule, but the schedule completely blows off. I think it is vital to inform you that we migrated our server from 7.1 to 7.5 a...

Our Server lies on Unix OS (HP-UX11.11) so definitely, Cron is being used.
But we schedule the job through Datastage scheduling UI provided in DS director.

We also saw the Cron Tab and the schedule is also no longer visible here as well.

We are running Datastage server edition version 7.5.1.A

We schedule all our production datastage inerfaces through Datastage scheduler.

Strangely almost half of the datastage top level batches are getting automatically unscheduled.

Please can anybody suggest the cause or solution to this.

Regards

As Craig has pointed out, you can pass the id valuet down your link as a field in the row, then make that a Key field in your update stage. But still, if you need to use the job parameter for comparison in the where clause, you can set this parameter in the subroutine(using the DSSetparam) at the ru...

I need to create a DSN in unix so that I could import table definitions from a remote source. If anyone knows please suggest how I could do it . Thanks First you need to create the ODBC connection(if it doesnt' already exists) in .odbc.ini file with all the connection details, then you need to the ...

chulett wrote:Special characters meaning this column name was the problem? 'I4SEQ#'

Yes Craig the column 'I4SEQ#' was the trouble.

The reason for hte attached problem was.
The version 7.5.1.A does not support special characters in the tables.

We had to install a more recent ODBC drivers (suffix - 222) and it solved our problem.

We have recently migrated Datastage server Edition engine from 7.1 to 7.5 on production and for few of the ODBC stages which were working fine earlier on UAT have given error on Production when connecting to AS400 source machine. The error message at Datastage end is as follows LoadIMSMITBON1PFromAS...

We have recently migrated from 7.1 to 7.5 in the UAT. In UAT an ODBC stage is giving an error as follows (I can see from the logs that the same error was generated before migration as well but the problem is that for the same job it is not giving the error on production which is currently running on...