DSXchange

Hi
Trying to setup connection from Datastage 7.5.3 on server A (Unix) to DB2 UDB on Server B (Unix) using a non-interactive id. Did any one work on this kind of scenario and what are the settings to be taken care on Db2 UDB database and the Datastage server.

Regards
dsxdev

Hi, Going by the info it looks like a simple job reading data from a Sequential file and just output to a DB2 Stage. A job with Sequential File Stage and DB2 stage as Target only. The low record processing speed could be because of the speed of response from DB. If the data base can process the reco...

hi Abhilash. From the error message it looks like rsh could not be invoked on dbsp8003, dbsp8004 nodes. This could be for one reason. Remote host entries are missing from .rhosts file. Make sure that entry of all the nodes are present in .rhosts file on each node. This file is present in your home d...

Hi Ambuj, I hope your case is to use a job which will read an empty file and generate a new file with a record containing default values. Since you are using this job to compare with another file, this job would be run conditionally. More precise run this job only when the input file for this job is...

hi Srekant, if you are using Job parameters then you need to pass the date part in the file name as Job parameter. now it depends on how you are invoking your job if it is through a unix script then use cut command to get date, which you have already done it. When you invoke your job using dsjob uti...

hi jayantthakore, i agree with Shails. In DataStage to find max value in a column, you need to use Aggregator Stage. Output of an aggregator stage is a decimal value. To find max value of column SAMPL(1900-01-01) You need to conver it to date first and then convert it to julian date then use this ju...

The problem look like is with improper compiler options.

Hi Any stage will execute only when it gets an input or gives an output. In your case the job design is like DB2 -----> Transformer ------> DB2 For your target DB2 Stage to execute yo need to output a record from Transformer and for Transformer to output there shoudl be a record input. So in your so...

Hi pnchowdary,

I am sure this piece does not work.
I tried it out but in vain.
By the way in which pdf talks about these function.
I would appreciate if any one can provide any pointers to these pdf's

Hi ArndW are you sure that the quote is the real problem if so Is it the issue with ODBC stage only. We have been using ' in many of my of our jobs in DB2 Stages and they work fine. In any case ' should not be a problem because in the query we are not expecting Data Stage to interpret the ' as part ...

Hi Ascential Documentation says Modify Stage is very efficient stage. I tried using it one of my jobs. My requirement is to chek in a nullable column for nulls and convert them into a default value. So I tried the following syntax. AGE_OUT=NullToValue(AGE_IN,-1) But it gives an error saying unidenti...

Hi, I hope here the problem is with the null handling on file stage you need to define null field value for the nullable fields. In Full outer join can tell me how many records are there from left link and how many records from right link. Take example From left link and right link you have 5 record...

Hi In case you are using auto generated query in database stage with lookup type as sparse then the column names of columns used for lookup need to be same in both reference and input link. They also need to be checked as keys in columns tab of reference link. In a sparse lookup you have to have the...

Hi
For all nullable columns coming from source you can check for nulls using
IsNull() function. But or not null columns in numeric fields you get defaults values as 0 and for varchar fields it is ''.
So for not null varchar fields you get '' for non matching records.

Hi, You can reduce the number of warning by changing the metadata. if you still get lot of warnings you can abort the job after 50 or more warnings. For this you can set limit on warnings while runing from Designer or Director by setting limits in limits page of window that pops up when you run the ...