DSXchange

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

Hi
I tried the first one get_projects_list.
My version is
Python 2.7.5 (default, Jun 11 2019, 14:33:56)
[GCC 4.8.5 20150623 (Red Hat 4.8.5-39)] on linux2

On windows it works ...

Thanks.


[/code]

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

Hi,

Sorry for the delay, I missed the notification.
Your answer is the one that i was afraid of, even if my previous post was incomplete.

We have two behaviours:

1) Relaunch ok without any actions
2) Relaunch ok after a clear status of the aborted instance

Thank you.

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.

Hi
The mydate column is a date.
The select was launched with sqldeveloper.
Thanks

The following sql gives this Like I said i'm using RCP so i don't declare any datatypes

In fact the problem comes from a fals date (00/01/3689) in a timestamp column.
To handle that i have to declare the column in varchar(10).
Thanks

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...

Hi,
The class_names for POSTGRESQL is org.postgresql.Driver.
I'm using the driver postgresql-42.2.6.jre6.jar.
Regards

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.

Hi
You can manually lock and unlock them yourself --> Can you tell me more about this ?
Thanks

Hi UCDI
To be honest with you i don't understand your answer.
What is DS Locking ?
Thanks

Hi
What do you think of using the C API (DSLockJob)?
Regards.

Hi
We are using gitlab as cvs.
What we want do to is locked the job even nobody is on it in a client.
Thank you.