Search found 10 matches

by shankararunn
Mon Apr 25, 2016 10:28 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem loading timestamp using ODBC Connecter
Replies: 8
Views: 10604

Hi - Did you get any solution for this ? I am also facing the same issue in ODBC connector ? kindly help
by shankararunn
Tue Apr 19, 2016 5:18 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Timestamp issue in ODBC stage of Vertica Database
Replies: 3
Views: 2605

Timestamp issue in ODBC stage of Vertica Database

In input i am receiving the timestamp as 2016-04-05-19.23.38.453000 in string format and need to convert it to timestamp as 2016-04-05 19:23:38.453000. I used timestamp from string function in transformer, but its failing in the insert saying " ODBC Info: SQLSTATE = 22008: Native Error Code = 4...
by shankararunn
Mon Jan 12, 2015 8:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Validation Against the XSD
Replies: 0
Views: 1323

XML Validation Against the XSD

Hi - I just want to restart the discussion started here. I want to use XML transformer stage in 9.1 to validate the XML column using XSD. But even though the XML tag has string value instead of Decimal , the record is writting successfully in the output file even though i selected reject in Warning,...
by shankararunn
Tue Aug 12, 2014 8:18 pm
Forum: General
Topic: How to invoke diffapi command from Citrix?
Replies: 12
Views: 4725

Hi - I have around 1000 jobs to do a compare which would need a batch process do to which is more time efficient.

My Datastage is installed in Linux and accessing it via CITRIX, so I am curious to know whether this command will be executed in the Linux server where the Datastage is installed ?
by shankararunn
Tue Aug 12, 2014 6:21 am
Forum: General
Topic: How to invoke diffapi command from Citrix?
Replies: 12
Views: 4725

Thank you. Sorry for multiple Q's.

My Datastage is installed in linux server but i guess this command is for windows. If it is for linux then can you please let me know how to identify the folder from where I have to run this command ?
by shankararunn
Sun Aug 03, 2014 7:10 pm
Forum: General
Topic: How to invoke diffapi command from Citrix?
Replies: 12
Views: 4725

Craig..I am sorry ..I tried to login to Linux server and i did the given command, but its saying this diffapi cpmmand is not present.

Do I need to go to some folder and then I need to try this command ?
by shankararunn
Fri Aug 01, 2014 10:38 am
Forum: General
Topic: How to invoke diffapi command from Citrix?
Replies: 12
Views: 4725

My Datastage software is in citrix and I can access the linux server thru PUTTY where the datastage is installed. So Can i execute this command from linux server
by shankararunn
Thu Jul 31, 2014 7:38 pm
Forum: General
Topic: How to invoke diffapi command from Citrix?
Replies: 12
Views: 4725

How to invoke diffapi command from Citrix?

Hi , I think its time to re-open this post. Actually I am accessing datastage via citrix, I don't have the Datastage installed in my laptop, so can you please let me know how to invoke this diffapi command ?
by shankararunn
Thu Jul 31, 2014 12:29 pm
Forum: General
Topic: NoSQL in 9.1
Replies: 2
Views: 1346

Thanks Craig, I am new to the Forum. My Dastage 9.1 is installed in LINUX server and I am accessing it thru CITRIX. In 8.5 I access NoSQL DB ( Cassandra ) thru Java stage. But I am not sure the same thing should be followed in 9.1 to connect Cassandra. Option 1 : Install driver to access , if so ple...
by shankararunn
Thu Jul 31, 2014 6:44 am
Forum: General
Topic: NoSQL in 9.1
Replies: 2
Views: 1346

NoSQL in 9.1

Hi - May I know how to access NOSQL DB via Datastage 9.1 ?