Running SQL queries from linux

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
karthi_gana
Premium Member
Premium Member
Posts: 729
Joined: Tue Apr 28, 2009 10:49 pm

Running SQL queries from linux

Post by karthi_gana »

All,

is it possible to execute a simple select * from DS_JOBS query from linux?

i just connected the linux box through putty.
Karthik
eph
Premium Member
Premium Member
Posts: 110
Joined: Mon Oct 18, 2010 10:25 am

Post by eph »

Hi,

You can run uv queries using uvsh command line tool.

Assuming that you have an sqlplus like app, with the correct credentials, it is possible to run quite the same query with the xmeta repository (if you're using an Oracle repository).

Regards,
Eric
Post Reply