DSXchange

Hi I am trying to understand, what osh is? I understand osh code gets generated for every DataStage EE job & one can view the same through generated osh through job properties window. Can it be the way, if only osh script is written, but no corresponding datastage job there in DataStage reposito...

Its great I could find DSParams file, which is part of projects directory. But it was not at the default location. I had to search from the root to go to the projects folder. After installation like .dshome, is there any file which has path information stored within to point to the different project...

Hi DSGuru

How will go to the project home?

Since .dshome represenet DS Engine home directory? Where will you look for?

In AIX environment, is there any way to find out what value has been set for APT_CONFIG_FILE for the datastage environment?

The reason I am asking this, I dont have an access to DataStage administrator. So I want to know, if environment is using configuration file other than "default.apt"?

Can we have, two or more specifications together for the derivation of a single column, as described in my previous post?

Can we have, two or more specifications together for the derivation of a single column, as described in my previous post?

Can we have, two or more specifications together for the derivation of a single column, as described in my previous post?

Specification to convert string to int day of the year, is as below - Joining_Day:int8=year_day_from_date(date_from_string[%dd-%mm-%yyyy](JoiningDate)) For this specification, I am getting following error. main_program: Error parsing modify adapter: Error in binding: Error in source field selector: ...

My final intention is to get day of the year. To achieve this I have converted String representation day into date format. Further I tried to get day of year by using 'year_day_from_date' function within same Modify stage. For this I get runtime error. If I have to convert String format of a date to...

Problem resolved. Thanks.

Char 10 is the datatype of the field in question.

Schema as requested.

Name - Varchar
Org - Varchar
Year - Integer
Joining_Date - char(10)

After I try to convert string format of date value to a date data type using modify stage, I get error below. APT_CombinedOperatorController,2: Un-handled conversion error on field "JoiningDate " from source type "string" to destination type "date": source value="1...

Through DataStage Director I have checked the error. I am getting following error.

Field "JoiningDate" has import error and no default value; data: {1 6 - 1 2 - 2 0 0 2}, at offset: 19

This error is observed for all records for this field.

I have flat file (sequential file), having one column containing date values in AIX unix environment. Since its format is fixed as dd-mm-yyyy, I can suitably define char(10) data type for it. When I go for View data for that stage, it is displaying data properly. If I try to load the same data in Da...

Hi Vincent

From this link ( http://www-03.ibm.com/certify/certs/iisdwsdev75.shtml )I got to know you should have 75 ans correct out of 79. That comes around 95%. But you mentioned you picked up 88%.

How is that? What is the minimum passing score required?

Thanks,