Search found 24 matches
- Mon Jan 29, 2018 1:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: RDS Postgres connection error
- Replies: 1
- Views: 1422
RDS Postgres connection error
Getting the following error when attempting to connect to Amazon RDS Postgres database using a JDBC connector. main_program: Fatal Error: The connector failed to connect to the data source. The reported error is: org.postgresql.util.PSQLException: FATAL: database "XXXXX " does not exist Bu...
- Thu Jan 25, 2018 2:10 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trying to connect to RDS Postgres on Amazon AWS
- Replies: 3
- Views: 2801
- Wed Jan 24, 2018 10:25 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Trying to connect to RDS Postgres on Amazon AWS
- Replies: 3
- Views: 2801
Trying to connect to RDS Postgres on Amazon AWS
Can I connect directly to RDS Postgres in Amazon AWS ? I have DS 11.3. If so, which type of connector do I use ? Thanks Rick
- Mon Jun 05, 2017 3:37 pm
- Forum: General
- Topic: put a 15 minute delay in the next execution of a start loop
- Replies: 4
- Views: 3999
put a 15 minute delay in the next execution of a start loop
trying to have a 15 minute delay between each execution of a start and end loop.
How can I accomplish that.
Thanks
Rick
How can I accomplish that.
Thanks
Rick
- Thu May 25, 2017 10:08 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Can I use RCP for a multi table select
- Replies: 1
- Views: 2009
Can I use RCP for a multi table select
i would like to use RCP for select statements that gather columns from various tables. Can I do that, and if so, how do i do that.
Thanks
Rick
Thanks
Rick
- Wed May 10, 2017 9:12 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how can i call a function on an insert statement
- Replies: 3
- Views: 2012
- Wed May 10, 2017 8:41 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: how can i call a function on an insert statement
- Replies: 3
- Views: 2012
how can i call a function on an insert statement
Hi,
I am extracting data from one DB source and inserting it into another. On the insert I need to call a function to encrypt one of the fields being inserted. How do I do that in Data Stage.
Thanks
I am extracting data from one DB source and inserting it into another. On the insert I need to call a function to encrypt one of the fields being inserted. How do I do that in Data Stage.
Thanks
- Fri Mar 24, 2017 4:01 pm
- Forum: General
- Topic: Using JDBC connector to POSTGRES , current TS is wrong
- Replies: 1
- Views: 1809
Using JDBC connector to POSTGRES , current TS is wrong
The time changed recently to day saving time, but the current_timestamp received when running a job in DS is still 1 hour behind.
This is only an issue on the JDBC connection to POSTGRES. Additionally, when I run the same query directly against the POSTGRES db, I get the correct time.
This is only an issue on the JDBC connection to POSTGRES. Additionally, when I run the same query directly against the POSTGRES db, I get the correct time.
- Fri Mar 10, 2017 3:29 pm
- Forum: General
- Topic: Read a file name from a unix server in Data Stage
- Replies: 3
- Views: 2461
Read a file name from a unix server in Data Stage
hi,
I need to look for the existence of a file with current date in the name.
And then pass that name information to a data stage job.
Can you help?
Thanks
Rick
I need to look for the existence of a file with current date in the name.
And then pass that name information to a data stage job.
Can you help?
Thanks
Rick
- Wed Jan 25, 2017 2:48 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: trying to load POSTGRES table with data from C-ISAM table
- Replies: 15
- Views: 8628
- Wed Jan 25, 2017 1:16 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: trying to load POSTGRES table with data from C-ISAM table
- Replies: 15
- Views: 8628
- Wed Jan 25, 2017 1:11 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: trying to load POSTGRES table with data from C-ISAM table
- Replies: 15
- Views: 8628
I am using a CONNX URL to read the data from the C-ISAM tables. And the purpose is to have the group that is using C-ISAM to move from C-ISAM to POSTGRES and still use the same program code to access the data. Therefore the Control Characters have to remain in the data. how do i attach a screen shot
- Tue Jan 24, 2017 7:08 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: trying to load POSTGRES table with data from C-ISAM table
- Replies: 15
- Views: 8628
yes this is the error Server:CSDPYETL01 Project:dev_rick Job No:228 Job name:IB_J0_IPS_POSTGRES_ALL Invocation: Event Number:3692 Event type:Info User:dsadm Timestamp:1/24/2017 7:22:34 AM Message Id:IIS-CONN-JDBC-30004 Message: JDBC_Connector_10,1: The connector encountered a Java exception: java.sq...
- Tue Jan 24, 2017 5:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: trying to load POSTGRES table with data from C-ISAM table
- Replies: 15
- Views: 8628
- Tue Jan 24, 2017 12:47 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: trying to load POSTGRES table with data from C-ISAM table
- Replies: 15
- Views: 8628
not exactly sure. They are being called control characters that are written by C# code. I am able to extract the data using UTF-8 from C-ISAM. Just unable to get that same data to load into POSTGRES, which is also set as UTF-8. in checking with the developer on the C-ISAM databaes, his response for ...