Hello Ray,
Thank you for your reply. I am, as part of the project, trying to have same sequence in both the tables i.e both the columns in the two tables must have same values when we compare row-by-row.
Can you help me in achieving this with DataStage please.
Thanks in advance.
-Yamini
Search found 379 matches
- Wed Nov 03, 2004 3:32 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using the same Sequence in multiple tables
- Replies: 6
- Views: 3080
- Wed Nov 03, 2004 3:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with DataStage Server installation
- Replies: 8
- Views: 4055
Problem with DataStage Server installation
Hello,
we have started the Server. When I am trying to run the job from DataStage Director, nothing is happening. No error messages are displayed and also I am not able to validate the job. Any idea what could be the problem.
Thanks in advance.
-Yamini
we have started the Server. When I am trying to run the job from DataStage Director, nothing is happening. No error messages are displayed and also I am not able to validate the job. Any idea what could be the problem.
Thanks in advance.
-Yamini
- Wed Nov 03, 2004 1:31 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Using the same Sequence in multiple tables
- Replies: 6
- Views: 3080
Using the same Sequence in multiple tables
Hello there,
Can I use the sequence generated by 'KeyMgtNextValue' in table A to be the sequence in table B. My intension is to use same sequence in both the tables.. If so, can anyone explain to me how to achieve this.
Thanks in advance.
-Yamini
Can I use the sequence generated by 'KeyMgtNextValue' in table A to be the sequence in table B. My intension is to use same sequence in both the tables.. If so, can anyone explain to me how to achieve this.
Thanks in advance.
-Yamini
- Wed Nov 03, 2004 1:27 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Problem with DataStage Server installation
- Replies: 8
- Views: 4055
Problem with DataStage Server installation
Hello there, We are trying to test the DataStage Server installed recently on UNIX machine. I tried to run a simple job and was able to successfully compile the job. But when I try to execute the job, nothing happens. No error message is displayed and also there is no entry in the log. Can onyone hl...
- Wed Nov 03, 2004 1:26 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Problem with DataStage Server installation
- Replies: 3
- Views: 1091
Problem with DataStage Server installation
Hello there, We are trying to test the DataStage Server installed recently on UNIX machine. I tried to run a simple job and was able to successfully compile the job. But when I try to execute the job, nothing happens. No error message is displayed and also there is no entry in the log. Can onyone hl...
- Tue Nov 02, 2004 4:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Erros in using Transformer Stage
- Replies: 7
- Views: 2506
Loading columns in the target database
Hi Amitava,
Thank you very much for your help.
-Yamini
Thank you very much for your help.
-Yamini
- Tue Nov 02, 2004 3:46 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Erros in using Transformer Stage
- Replies: 7
- Views: 2506
Loading columns in the target database
Hello Amitava,
Thank you once again for your help. Can you explain to me how to use the transformer present in the repository of DataStage Manager in DataStage Designer.
I appreciate your time.
-Yamini
Thank you once again for your help. Can you explain to me how to use the transformer present in the repository of DataStage Manager in DataStage Designer.
I appreciate your time.
-Yamini
- Tue Nov 02, 2004 1:01 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Erros in using Transformer Stage
- Replies: 7
- Views: 2506
Loading columns in the target database
Hello Amitava,
Thank you for your reply. How can I know what transfromer(Basic or Parallel) I have. Basically, there is only one Transformer under 'Processing' section.
-Yamini
Thank you for your reply. How can I know what transfromer(Basic or Parallel) I have. Basically, there is only one Transformer under 'Processing' section.
-Yamini
- Mon Nov 01, 2004 6:13 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Urgent Help On installation procedure for DataStage PX
- Replies: 4
- Views: 2558
Re: Urgent Help On installation procedure for DataStage PX
Hello,
Yes you can setup a self loop on the machine to have the server run on Linux and client on Windows.
-Yamini
Yes you can setup a self loop on the machine to have the server run on Linux and client on Windows.
-Yamini
- Mon Nov 01, 2004 3:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading columns in the target database
- Replies: 3
- Views: 1575
Loading columns in the target database
Hello Ray,
Can you elaborate how to specify the method to 'Update' in DataStage Designer.
Thank you for your hlep.
-Yamini
Can you elaborate how to specify the method to 'Update' in DataStage Designer.
Thank you for your hlep.
-Yamini
- Mon Nov 01, 2004 12:40 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Loading columns in the target database
- Replies: 3
- Views: 1575
Loading columns in the target database
Hello there, I am trying to load columns in the target table. The problem is that the data for some of these columns is coming from one source table and for the remaining tables, it is coming from different source table. I tried to accomplish this task as a two step process. In the first step, I loa...
- Mon Nov 01, 2004 11:36 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Erros in using Transformer Stage
- Replies: 7
- Views: 2506
Erros in using Transformer Stage
Hello there, If am using Transformer Stage in a Prallel job, I am getting errors like 'Operator error'. In the same job, if I use another stage, the job is compiling successfully. My question is 'Is there any problem with the Transformer Stage.' Does this problem relate to the C++ Compiler. Can anyo...
- Fri Oct 29, 2004 12:34 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Getting Day from Date
- Replies: 2
- Views: 1166
Getting Day from Date
Hello there,
Can anyone explain to me to get Day from 'yyyy-mm-dd 00:00:00'
format.
Thanks in advance.
-Yamini
Can anyone explain to me to get Day from 'yyyy-mm-dd 00:00:00'
format.
Thanks in advance.
-Yamini
- Thu Oct 28, 2004 3:37 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Parallel Transformer stage errors
- Replies: 3
- Views: 2242
Parallel Transformer stage errors
Hello there, I am trying to execute a simple parallel job. The design of the job is: SEQ ==>Transformer ==>SEQ. I got the following error during the execution: Error when checking composite operator: Subprocess command failed with exit status 65280 Can anyone help me in correcting the error. Thanks ...
- Thu Oct 28, 2004 12:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error while executing parallel job
- Replies: 9
- Views: 6292
Error while executing parallel job
Hi, The design of the job is simple. SEQ ==> Transformer ==> SEQ. I got the following error: Output from transformer compilation follows: ##I TFCN 000001 10:11:29(000) <main_program> DataStage XE Parallel Extender V7.0.1 Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc. All Rights Reserved ##...