Search found 32 matches

by akhiln
Mon Feb 27, 2006 5:34 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Could not load drsoci.dll
Replies: 1
Views: 1479

Could not load drsoci.dll

Hi All, While trying to run the server jobs, we are getting an error like this "Could not load drsoci.dll". Source database is SQL server and Target DB is Oracle. When the traget database was SQL Server the job was running fine. We are using the plugin stage "DRS" for the source ...
by akhiln
Tue Jan 10, 2006 3:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Loading Datas from CRM system to EPM System
Replies: 6
Views: 3549

Hi Vindy,

There will be a master sequencer for running all the staging jobs and master sequencer at the each datamart level for running the respective dimensions & Facts.

Thanks,
Akhil
by akhiln
Thu Dec 08, 2005 4:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error occurred during link open process
Replies: 7
Views: 2901

I don't know what's the actual error is......but you can run the job by giving "array size to 1"
by akhiln
Tue Nov 29, 2005 9:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Adding description to jobs
Replies: 8
Views: 3756

Yes, You can do that using any of the programming languages like PERL, C etc. First export the jobs(only Job Designs) you want to change the descriptions. Then write a PERL script which will take this dsx as the input file and whereever you find the keyword "FullDescription"......give your...
by akhiln
Thu Oct 13, 2005 11:40 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: The performance of IPC stage
Replies: 2
Views: 2304

IPC provides a communication channel between DataStage processes running simultaneously in the same job. It allows you to design jobs that run on SMP systems with great performance benefits. One can use them to speed up data transfer between two data sources(eg: a source and target).
by akhiln
Tue Oct 04, 2005 2:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Link order of execution
Replies: 3
Views: 1560

Why you need a separete link for clearing the hash file. You can check the "Clear file before writing" option in the hash file.

Thanks,
Akhil
by akhiln
Thu Aug 11, 2005 1:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: To run all the jobs in a project from command prompt
Replies: 5
Views: 2075

To run all the jobs in a project from command prompt

Hi All,

Is it possible to run all the jobs available in a Project from the command prompt?

There is one command to run a single job from the command prompt.
"dsjob -run Project Job". Like this any command to run all the jobs in a project.

Thanks,
Akhil
by akhiln
Mon Jul 11, 2005 12:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01036 Illegal variable name / number
Replies: 12
Views: 6074

Thanks Chulett. When i included the hash file after the DRS stage its working fine. Thank you very much.
by akhiln
Sun Jul 10, 2005 10:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01036 Illegal variable name / number
Replies: 12
Views: 6074

Yes i want to run this complex query. I cannot do any changes with the tables & the logic. Is it possible to do something with the datastage to avoid this kind of errors.
by akhiln
Fri Jul 08, 2005 2:56 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01036 Illegal variable name / number
Replies: 12
Views: 6074

Dynamic Relational Stage(DRS). It can be configured at runtime to read from or write to a number of different supported relational database management systems using native interfaces.

Thanks,
Akhil
by akhiln
Fri Jul 08, 2005 2:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01036 Illegal variable name / number
Replies: 12
Views: 6074

I didn't find any "Pre 4.2 User defined Sql" option. My lookup is a DRS stage.

I cannot change the "where" condition. Is there any other way of solving this issue.
by akhiln
Fri Jul 08, 2005 12:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01036 Illegal variable name / number
Replies: 12
Views: 6074

ORA-01036 Illegal variable name / number

Hi All, I am getting an error like this "ORA-01036 Illegal variable name / number". I have a DRS lookup stage in that i am having an user-defined query like this SELECT A.LM_LRNR_OBJV_ID,A.SRC_SYS_ID,C.LM_PROF_MAP FROM PS_LM_LRNR_OBJV A, PS_LM_OBJV_TBL B, PS_LM_RVW_RTNG_MAP C WHERE A.LM_RE...
by akhiln
Mon Jun 13, 2005 2:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01722: invalid number
Replies: 3
Views: 3137

Thanks Sreeni, One of the numeric field was getting some carriage return charater or space. The problem was with the source sequential file data.
by akhiln
Mon Jun 13, 2005 12:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: ORA-01722: invalid number
Replies: 3
Views: 3137

ORA-01722: invalid number

I am getting an error like ORA-01722: invalid number. I am writing to an ORACLE table. My source is a sequential file.

I checked all the columns and verified that numeric columns are getting only numeric values.

Any suggestions
by akhiln
Sun Apr 17, 2005 10:38 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Client Library property required for stage
Replies: 1
Views: 1158

Client Library property required for stage

While running jobs which contains DRS stage , the error which pops up is Client Library property required for stage ( DRS) and the job aborts.
DO any one have a idea why this error pops up??