DSXchange

Thanks Chulett for the prompt response.

Hi, I have query that when we migrate the jobs from DS7.5 server to DS 8.5 Server, DO we need to declare the parameter set and use it in the job or still server job will work with the parameters defined in the job properties without being using parameter set. Could anyone assist me in clarifying the...

Its designer user-id not the DB2 database stage. I am using Datastage 7.5.3 server edition on WIndows 2003.

Hi, Can anyone help me on the below issue. I am trying to view the data in designer with my individual userid through DB2 API stage, i am getting the below error "ds_loadlibrary: Win32 error in LoadLibrary of dsdb2.dll - A dynamic link library (DLL) initialization routine failed" but when ...

Thanks Ray for the prompt Response

Hi Folks,

Could any one assist us in clarifying the below query

I would like to read a password protected file in datastage. Is this be achievable in Datastage job? If yes, please provide us the way or steps.

Hi Folks,

Is it possible to read a PGP encrypted file in Datastage server or parallel job? If yes, could you please detail the steps to achieve this?

Hi, I came to know that we can read a PDF document through PDF converters using filter command in sequential file stage but never tried. Does anybody tried implementing the same? If yes, could you please share more about the process to acheive this. Also is it possible to write into a PDF file throu...

Hi,

Is it possible to read a word document and write the contents in different txt file through a datastage job ? I think it is not possible. Does anybody tried or is there a way to read a word document through the DS job? please assist me

Hi,

I am using Datastage 7.5.3 server edition on windows platform. I need to merge 3 files into 1 file i.e., Header file, footer file and data file which has got different number of columns. Could anyone assist me in this.

Below is the actual warning

Transformer_118: At row 13947, link "DSLink122", while processing column "COY_CONTR"
Value treated as NULL
Attempt to convert String value " " to Double type unsuccessful

Hi,

I am trying to load null into decimal column from file into a table and it is throwing warning. I have used Isnull function and tried to load space instead of null but it is throwing warning message. Can any one assist me in loading null into decimal without warnings.

HI,

I need to findout day of the date like for example if it is 28-Jan-2011 i need output as 'Friday'. Is there any functions to get this output. Can anyone help.

Hi, I am trying to join 2 hash files in a universe when i try to view data in universe, it's throwing below error 'SQLSTATE=S0002, DBMS.CODE=950390 [DataStage][SQL Client][UNIVERSE]DataStage/SQL: Table "hOCC_INVFACT_1" does not exist. I understand that need to set the pointer but i don't k...

Hi,

We are trying to extract the data from oracle database from ODBC stage and loading into Teradata. Job is hanging at trace mode level and not able to extract data from oracle. Could you please assist us what might be the problem and how can we resolve this issue?