Hi,
Thanks again. I could view the data with the same oracle connection for server jobs but i am having the problem when i try to view the data with parallel jobs,so I guess the problem exist with Datastage parallel configration
Search found 155 matches
- Thu Nov 24, 2005 6:23 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error viewing data from Oracle
- Replies: 18
- Views: 7278
- Thu Nov 24, 2005 5:10 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error viewing data from Oracle
- Replies: 18
- Views: 7278
Hi, Thank you for the reply. Kindly let me is this an oracle installation issue or Datastage installation problem.Do I need to configure something in Datstage.I have installed datastage first and then Oracle .Does this has any impact.Is the problem because I am using 7.5.2 and installed Oracle 8.Kin...
- Thu Nov 24, 2005 4:45 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error viewing data from Oracle
- Replies: 18
- Views: 7278
Error viewing data from Oracle
Hi, I am trying to connect to oracle database. I have given the tablename,username,password and connection string.In server 7.5.2 it is working but in parallel i am geeting the following error when I am trying to view the data ##I TOSH 000002 16:15:38(001) <main_program> orchgeneral: loaded ##I TOSH...
- Wed Nov 23, 2005 8:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Exclusive rights to users
- Replies: 0
- Views: 582
Exclusive rights to users
Hello All, My Version is 7.5.2 parallel. My OS is Windows 2000 Advanced Server. I have created 2 Admin users.Eg:-Admin1 and Admin2 I need to set security permission to these users. I have gone to the project properties and in the security tab I have set the permission for the project. I am able to l...
- Fri Nov 18, 2005 5:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: COMMANDS
- Replies: 2
- Views: 793
COMMANDS
Hello,
I am trying to find the metadata of the repository items.I have tried the following option
LIST DS_METADATA.
Also please let me know the commands which I can use.
Thank u in advance,
Bala
I am trying to find the metadata of the repository items.I have tried the following option
LIST DS_METADATA.
Also please let me know the commands which I can use.
Thank u in advance,
Bala
- Fri Nov 18, 2005 5:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Universe tables
- Replies: 2
- Views: 943
Universe tables
Hello, Can I save my datas in universe tables?. I am trying to do this it gives the following error. Kindly let me know what to do? Fatal error-universe1..UniData_6_3.DSLink2: ds_uciopen() - Failed to connect to the database. Warning-Attempting to Cleanup after ABORT raised in stage universe1..UniDa...
- Thu Nov 17, 2005 7:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Extract source file through Routine.
- Replies: 3
- Views: 987
Extract source file through Routine.
Hello, My source file is a text file.The file delimter is comma but I am having some fileds has comma in it. I need to delete the comma in the field. I am trying this - I have created a file which has only one column(starting number is 1 and the ending number is count of number of rows my source fil...
- Thu Nov 17, 2005 3:31 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sending Job report to a file.
- Replies: 7
- Views: 2240
- Wed Nov 09, 2005 2:35 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sending Job report to a file.
- Replies: 7
- Views: 2240
Hello RK, These are the steps. 1.In the job parameter there is After sub-routine list. Select the DSjobReport If u see the routine in the manager u will understand what it does. In the Input value pass the file type,directory path.this is where is my problem.I do not understand how to pass or where ...
- Tue Nov 08, 2005 11:24 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sending Job report to a file.
- Replies: 7
- Views: 2240
- Tue Nov 08, 2005 8:34 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Sending Job report to a file.
- Replies: 7
- Views: 2240
Sending Job report to a file.
Hello All, I need to send my jobreport to a file. I am using a after-subroutine DSobreport to do that. I am passing the following as my input arument 1;c:\ I am getting the following warnings when I see the log in director. routine..AfterJob (DoJobReport): Failed to open directory C: Kindly help me ...
- Tue Nov 08, 2005 6:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Commandline running-dsjobs
- Replies: 2
- Views: 1031
Commandline running-dsjobs
Hi,
Can I run a job from command line in windows.I am using parallel extender Windows version(7.5.2).My server is a SMP. I need to get the logdetails of my job and i need to spool it to a file.Can anyone let me know how to do it in windows.
Regards,
Bala
Can I run a job from command line in windows.I am using parallel extender Windows version(7.5.2).My server is a SMP. I need to get the logdetails of my job and i need to spool it to a file.Can anyone let me know how to do it in windows.
Regards,
Bala
- Tue Nov 08, 2005 6:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error viewing the data(Null Archive)-Urgent
- Replies: 8
- Views: 3928
- Mon Nov 07, 2005 12:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error viewing the data(Null Archive)-Urgent
- Replies: 8
- Views: 3928
Hi, Here is the summary, When i tried to view the data thro' the sequential file - Parallel Edition i am getting the following error, ##I TFCN 000001 10:02:00(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights R...
- Wed Nov 02, 2005 12:05 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Error viewing the data(Null Archive)-Urgent
- Replies: 8
- Views: 3928
Error viewing data
Hi,
I apologise. I am trying to read data from a sequential file(1,2,3,4,5)
but when i am viewing it shows a Fatal Error.Null Archive.
Thank you
I apologise. I am trying to read data from a sequential file(1,2,3,4,5)
but when i am viewing it shows a Fatal Error.Null Archive.
Thank you