Search found 226 matches
- Mon Mar 18, 2013 3:25 pm
- Forum: General
- Topic: Controlling the execution of Jobs in Datastage Sequence
- Replies: 6
- Views: 2930
No - There is no such dependency. This sequence will be automated through scheduler -Which ever country file is created first will get the priority. We have a country code parameter at sequence level to differentiate. We would have created separate sequence for each country. But in future, we ould b...
- Mon Mar 18, 2013 2:44 pm
- Forum: General
- Topic: Controlling the execution of Jobs in Datastage Sequence
- Replies: 6
- Views: 2930
Controlling the execution of Jobs in Datastage Sequence
Hi Everyone, We need to design a sequence in such a way that it execute only required jobs and not all attached to that sequence. Sample Job Flow in Sequence. Extract --> Transform A1 --> Transform A2 --> Load Say, Our Sequence is designed to process data for 2 countries A1, A2. So, when it is runni...
- Tue Mar 12, 2013 8:47 am
- Forum: General
- Topic: Information Server Web Console Issue
- Replies: 2
- Views: 1635
- Tue Mar 12, 2013 8:15 am
- Forum: General
- Topic: Information Server Web Console Issue
- Replies: 2
- Views: 1635
Information Server Web Console Issue
Hi, We have V8.7 on Wondows 2008 R2 After logging on the Server that hosts the Information Server, when we try to login in the Information Server via the Web Console shortcut..it is not doing anything (does not go anywhere) when we hit the "Done" button after entering the correct credentia...
- Wed Feb 20, 2013 11:57 am
- Forum: General
- Topic: Multi Instance Job - DsJobInvocationId
- Replies: 4
- Views: 2273
By Not working I mean it does not update the record when we pass the Invocationid to be used as part of the Where Clause (We verified it is a valid value and should update 1 record) I already tried using the single quotes around it, as you suggested, but then it treats that as a string value and doe...
- Tue Feb 19, 2013 2:26 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Enterprise Stage - To access Mainframe File
- Replies: 5
- Views: 1972
- Tue Feb 19, 2013 10:40 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Enterprise Stage - To access Mainframe File
- Replies: 5
- Views: 1972
- Tue Feb 19, 2013 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: FTP Enterprise Stage - To access Mainframe File
- Replies: 5
- Views: 1972
FTP Enterprise Stage - To access Mainframe File
Hi, We are using FTP enterprise stage to connect and grab a file from Mainframe host. This connection is working perfectly fine when we are trying FTP using our own credentials. But somehow it's not able to grab the file using SFTP SSH connection URI - FTP://HOST//'MAINFRAME_FILE' TRANSFER_PROTOCOL ...
- Mon Feb 18, 2013 4:55 pm
- Forum: General
- Topic: Multi Instance Job - DsJobInvocationId
- Replies: 4
- Views: 2273
Multi Instance Job - DsJobInvocationId
Hi All, We have a scenario where we update the same audit table and column across multiple processes for different values in where clause, once when a Sequence job starts and finally as the last step when the Seq job ends. The only change in the update query across different seq jobs is the value in...
- Tue Feb 12, 2013 12:43 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Excel Connectivity Issues
- Replies: 1
- Views: 1650
Resolved this issue by creating the SYSTEM DSN from this path : C:\Windows\sysWOW64\odbcad32.exe instead of the default C:\Windows\System32\odbcad32.exe as we are in a 64-bit Windows Env. Then when I try to import the metadata using the ODBC Table Definition I am able to see the Excel file name but ...
- Tue Feb 12, 2013 9:52 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Excel Connectivity Issues
- Replies: 1
- Views: 1650
Excel Connectivity Issues
Hi All, We are on V8.7 on Windows Server 2008 R2 Standard (64 bit) We installed the Microsoft Excel and Access Drivers on the Engine Tier (Office 2010) and then created a System DSN for this Excel Driver accordingly. Then I tried opening an .xls file on the server and it is able to open it so I beli...
- Mon Feb 11, 2013 9:01 am
- Forum: General
- Topic: Datastage Dev and Production Projects in Same Environment
- Replies: 3
- Views: 1613
- Fri Feb 08, 2013 8:14 am
- Forum: General
- Topic: Datastage Dev and Production Projects in Same Environment
- Replies: 3
- Views: 1613
Datastage Dev and Production Projects in Same Environment
Hi All, V8.7 on Windows with Engine Tier on one Server and Services/Metadata Tier on another. We will have a Datastage project say PRDEV on this Env and on this same box (Environment) have another project called PRPROD..So basically both Dev and Production projects will reside on the same box..I und...
- Wed Feb 06, 2013 8:47 pm
- Forum: General
- Topic: Dsjob with Password Encryption
- Replies: 3
- Views: 2898
- Wed Feb 06, 2013 10:24 am
- Forum: General
- Topic: Dsjob with Password Encryption
- Replies: 3
- Views: 2898
Dsjob with Password Encryption
Hi All, When I run a job using dsjob and passing the user and password with other relevant infomation it runs successfully. dsjob -domain <Domain> -server <Server> -user uid -password pass -run -param Parameter_Set_Test=STAGE dstage1 JobName Then I try to run the same job but pass an Encrypted passw...