DSXchange

The partitioning on the lookup stage is set to auto. I do a lookup to the datastage where the key values, incomming and on the dataset, are varchar. This works when the varchar contains only numerics e.g. '13300' This does not work when the varchar contains non-numerics e.g. 'VDB_120'. Has anyone el...

I have a job sequence that has two 'wait for file' stages. The triggers from the 'wait for file' stages are set to OK. :? For some odd reason, the job sequence does not issue the two wait for files immediately. Only one wait for file is issued. When that file arrives, the next wait for file is issue...

Thanks for the reply. However, the client does not want to use the 'after job' option.

Hi Guys I'm using the bulk loader because of high data volumes. In the bulk loader I have the option to code a delete statement. The delete will delete any data loaded for a period and then re-load the data being pushed to it. This has been done to cater for re-runnability. However, if no rows go do...

Thanks for the replies. Problem is I don't have 'Premuim Support' so can't see the full answer.

My boss is getting a long , long justification...

Hi Guys Thanks for the replies. No constraint specified in the job. Out of 100 000 rows, get 15 with hyphens which do not appear in the hash file. The link information says that the rows were written to the hash file. I thought maybe it was a character that Datastage displayed, when using the 'view ...

Hi Guys I'm getting a strange occurrence when I build the hash file. The data in the source table contains a hypen i.e. '-' in this case the account number. A key column on the hash file is the account number varchar(15). Any account number with a hypen in it is not written to the hash file. There a...

We are currently using DS 7.5.1A server version and want to move to PX. Is it possible to simply export the server jobs (dsx) and import them into PX?

Thanks Ken and Ray, much appreciated.

Does anyone know where the documentation for the link variables is hidden away e.g. link constants. I have searched through all the documentation and cannot find anything about link variables except the basics about how to use them. One would expect a pdf to published.

Thanks for the reply. However, my OS is Windows, not Unix.

All I want to do is somehow identify those source files I recieve who's content is UTF8 encoded. I currently run this process manually and want to automate it.

I recieve several source files as input. Problem is I don't know which ones are UTF8 encoded. What I want to do is the following: Folder---Transformer---ODBC NLS set toUTF8 in the folder stage. The filename from the folder stage is written to the odbc. When I run the job, any source file that does n...

I need to connect to the following databases: Informix Dynamic Server 9.4 DB2 UDB 8.1.6 We are using the Data Direct Wire Protocol 4.2 drivers. We want to use the bulk loader stages for these databases (DB2 Load and Informix Loader stages). Strange thing is we can connect using the ODBC stage, but c...

I need to connect to the following databases: Informix Dynamic Server 9.4 DB2 UDB 8.1.6 We are using the Data Direct Wire Protocol 4.2 drivers. We want to use the bulk loader stages for these databases (DB2 Load and Informix Loader stages). Strange thing is we can connect using the ODBC stage, but c...

We run DataStage jobs daily. The database (Informix) is on a SAN and the hash files and sequential files are on the AIX server. The jobs are simple seq-->trfm-->seq in most cases with one or two hash file lookups. Hash files are large, most over 1,000,000 rows and at least 20 columns wide (not good ...