Search found 92 matches
- Tue Nov 20, 2018 1:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Are Job parameter names case sensitive?
- Replies: 1
- Views: 2343
Are Job parameter names case sensitive?
Hello there, Recently I recognized that a job parameter name, that I expect to be case sensitive, seems to work correctly when being used in a SQL database stage (in my case it is Oracle) in a SQL statement. It seem to be recognized at run time correctly even if being used in different upper/lower l...
- Thu Jan 25, 2018 8:07 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: subtract 1 microsecond from incoming timestamp
- Replies: 3
- Views: 3861
use function TimestampOffsetByComponents
At least in DataStage 11.x there is a function called TimestampOffsetByComponents, which also supports microseconds to be added/subtracted in the seconds-component... :D
Cheers
Klaus
Cheers
Klaus
- Wed Aug 10, 2016 6:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Duplicate entry issue - Lookup stage
- Replies: 12
- Views: 12950
- Tue Jul 21, 2015 5:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Schema file error
- Replies: 13
- Views: 8707
- Fri Jun 12, 2015 2:08 am
- Forum: General
- Topic: Calculating Distance between Latitude/Longitude points
- Replies: 8
- Views: 11290
- Wed Jun 10, 2015 8:29 am
- Forum: General
- Topic: Numerous backslashes in dsx export
- Replies: 4
- Views: 4654
- Wed Jun 10, 2015 4:33 am
- Forum: General
- Topic: Numerous backslashes in dsx export
- Replies: 4
- Views: 4654
Numerous backslashes in dsx export
Hi there, has someone ever experienced that a dsx-export may contain numerous (thousands!!) of backslashes - one after the other. This seems to happen with server jobs that contain an ORACLE connector stage only. I cannot verify this exactly, but most of our jobs are parallel jobs and the server job...
- Fri Jan 23, 2015 10:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL statement ORA lookup
- Replies: 2
- Views: 3029
- Fri Jan 23, 2015 5:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: SQL statement ORA lookup
- Replies: 2
- Views: 3029
SQL statement ORA lookup
Hi folks, I am in the process of redesigning server jobs to parallel. I have a lookup to an ORA-DB in the old server job that has is user defined sql: "SELECT :1 TEXT, REGEXP_SUBSTR(REGEXP_REPLACE(UPPER(:1), '[^a-zA-Z0-9]', '', 1, 0), '[BK][0-9]{1,8}') TRANSAKTIONSCODE FROM dual" and runs ...
- Mon Mar 24, 2014 9:48 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Stage - instance connection issue
- Replies: 4
- Views: 4947
Re: DB2 Connector Stage - instance connection issue
Hi MT,
thanks for your suggestion. As I mentioned in my issue describtion, leaving "Instance" blank gives an error. As I mentioned I am on windows, so there is no dsenv....
Best regards
Klaus
thanks for your suggestion. As I mentioned in my issue describtion, leaving "Instance" blank gives an error. As I mentioned I am on windows, so there is no dsenv....
Best regards
Klaus
- Fri Mar 21, 2014 9:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: DB2 Connector Stage - instance connection issue
- Replies: 4
- Views: 4947
DB2 Connector Stage - instance connection issue
Hi there :D I have an issue with DS(IS) 9.1 and DB2 10.1, both on one machine, OS Win Server 2008: I can run "classic" server jobs with DB2 API stage without problems. When trying a parallel job and DB2 connector stage I get "An error occurred setting DB2 instance to value . The activ...
- Wed Feb 12, 2014 9:13 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: link report not found
- Replies: 13
- Views: 18002
- Thu Dec 05, 2013 8:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Warning while deleting dataset by Job
- Replies: 8
- Views: 7604
- Fri Oct 25, 2013 12:53 am
- Forum: General
- Topic: Best Auditing Approach in version 8.5 onwards
- Replies: 9
- Views: 5888
Re: Best Auditing Approach in version 8.5 onwards
Hi Sachin, we do this running DSJobReport (report type 2/XML) for every job as an after job subroutine. It delivers everything you mentioned exept a Batch_id, which is your own thing. Later we process these XMLs to be stored into a DB table for auditing. While this works pretty fine you have to be a...
- Thu Aug 15, 2013 2:01 am
- Forum: General
- Topic: Need to check if two files exist then only process?
- Replies: 6
- Views: 3905
Re: Need to check if two files exist then only process?
Did you try "wait for file" event in job sequencer...?
Klaus
Klaus