Hi all
I would like to know if any of you have had the following problem :
Sometimes some jobs (after an execution ok) have their status returns to compiled.
We have to do a clear status to solve the issue.
Thank you
Search found 194 matches
- Tue Jun 16, 2020 8:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Status compiled
- Replies: 1
- Views: 14698
- Sun May 17, 2020 2:54 am
- Forum: General
- Topic: API datastage Python
- Replies: 2
- Views: 15255
- Sun May 10, 2020 5:19 am
- Forum: General
- Topic: API datastage Python
- Replies: 2
- Views: 15255
API datastage Python
Hi
I try to use python with datastage.
I found this link https://github.com/reijnnn/IBM-DataStage-API.
I can't connect to datastage not matter what i tried.Error 80011 wrong password
Do you have any advice ?
Thank you
I try to use python with datastage.
I found this link https://github.com/reijnnn/IBM-DataStage-API.
I can't connect to datastage not matter what i tried.Error 80011 wrong password
Do you have any advice ?
Thank you
- Wed Jan 29, 2020 12:52 am
- Forum: General
- Topic: Job aborting due to empty parameters from sequence
- Replies: 3
- Views: 15037
- Thu Jan 23, 2020 4:13 am
- Forum: General
- Topic: Job aborting due to empty parameters from sequence
- Replies: 3
- Views: 15037
Job aborting due to empty parameters from sequence
Hi,
When calling a parallel job from a job sequence, sometimes the job fails because its parameters are empty. The job sequence and the parallel job are multi-instanced.
When we try again it works.
When calling a parallel job from a job sequence, sometimes the job fails because its parameters are empty. The job sequence and the parallel job are multi-instanced.
When we try again it works.
- Wed Dec 25, 2019 11:41 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Connector Oracle Error
- Replies: 7
- Views: 7510
- Thu Dec 19, 2019 1:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Connector Oracle Error
- Replies: 7
- Views: 7510
The following sql
gives this
Like I said i'm using RCP so i don't declare any datatypes
Code: Select all
select ID,TO_CHAR(MYDATE, 'DD/MM/YYYY hh24:mi:ss'),cast(MYDATE as timestamp) from MYTABLE where ID=1
Code: Select all
1 00/01/3948 00:00:00 31/12/47 00:00:00,000000000
- Wed Dec 18, 2019 5:20 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Connector Oracle Error
- Replies: 7
- Views: 7510
- Mon Aug 12, 2019 9:32 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Inserting decimal in Postgresql
- Replies: 0
- Views: 3212
Inserting decimal in Postgresql
Hi We can't insert values in decimal (numeric) columns in a postgresql database using datastage. Via ODBC we have this error ODBC_NOMTABLE,0: ODBC function "SQLExecute" reported: SQLSTATE = 22018: Native Error Code = 0: Msg = [IBM (DataDirect OEM)][ODBC PostgreSQL Wire Protocol driver]Inva...
- Mon Aug 12, 2019 9:26 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Postgresql JDBC
- Replies: 2
- Views: 3982
- Mon Aug 12, 2019 2:29 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Postgresql JDBC
- Replies: 2
- Views: 3982
Postgresql JDBC
Hi
I would like to use the jdbc connector with postgresql.
I have dwonloaded the jdbc driver (postgresql-42.2.6.jar)
I know i have to fill the fill isjdbc.config but i don't know how (CLASS_NAMES part)
Thank you.
I would like to use the jdbc connector with postgresql.
I have dwonloaded the jdbc driver (postgresql-42.2.6.jar)
I know i have to fill the fill isjdbc.config but i don't know how (CLASS_NAMES part)
Thank you.
- Sun Jun 23, 2019 10:15 am
- Forum: General
- Topic: Check in datastage
- Replies: 14
- Views: 29657
- Sat Jun 22, 2019 6:49 am
- Forum: General
- Topic: Check in datastage
- Replies: 14
- Views: 29657
- Sun Jun 16, 2019 9:19 am
- Forum: General
- Topic: Check in datastage
- Replies: 14
- Views: 29657
- Tue Jun 11, 2019 5:15 am
- Forum: General
- Topic: Check in datastage
- Replies: 14
- Views: 29657