DSXchange

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

Thanks. I had been using a jdbc connection for regular postgres, but are you saying that I should try the ODBC connection for RDS Postgres ?

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

trying to have a 15 minute delay between each execution of a start and end loop.

How can I accomplish that.


Thanks


Rick

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

I tried that, but the insert didn't execute the function

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

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.

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

Actually, I posted the values to the site already,,,

here is what is in the column in hex

BRN_states_001
--------------
efbfbdefbfbd

Okay, I figured out how to get at least one of the values to display in hex

here is what is displaying in one of the columns

BRN_states_001
--------------
efbfbdefbfbd


Thanks

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

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

They have to be loaded AS-IS

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