PLI on AIX question


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers PLI on AIX question
# 1  
Old 01-15-2007
PLI on AIX question

Hi, all.

Can someone please help me with one problem?
Maybe it's very simple but I have confused with it and need the help please.

I have some PLI programs to be moved from MVS to AIX. These programs contain some SQLs on unqualified tables (for ex., select * from table1).
When I compile such program on aix, precompiler substitutes the current AIX UserID as schema name.
That is I have select * from myUserID.table1.

In which way I can specify the need table qualifier (for ex., owner1) to be used before compilation?
That is I need to have
select * from owner1.table1.

I though that I could specify this as some SQL preprocessor option, but I could find nothing to do it.

Thank you in advance.
Anta
 
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. AIX

Some question about AIX

I have some question about aix: i know many unix system(hpux,solaris,etc) but never work with aix.. First question: updates/fixes are free or only commercial support? Second: Is easy like hpux,there are many differences between aix and other unix system? Thanks (5 Replies)
Discussion started by: Linusolaradm1
5 Replies

2. AIX

AIX IP security question

Recently the network auditor found a security hole at port 50000. The port 50000 is used by db2. When I enter command "netstat -Aan |grep 50000", it showed some established connections and are all db2 processes. I have asked the application team and they answered that the port 50000 connection... (2 Replies)
Discussion started by: skeyeung
2 Replies

3. AIX

AIX v5.2 Printer Question

Hi All, I have an AIX server runing v5.2.0.0 OS and i am trying to print to a printer attached to the parallel port. I have successfully configured a printer and a print queue. However, when i submit the job i get the following error Message from queueing system: 0781-088 Queue z:lp0 went... (4 Replies)
Discussion started by: rramanuj
4 Replies

4. AIX

AIX question..

Hi, There is a script runs as a specific user called "unixusr". But we don't want to give the access to the other teams to run as that id as that id owns lot of system binaries and libraries in other directories.. So can we create another id called "intusr" and internally set something in this... (3 Replies)
Discussion started by: everurs789
3 Replies

5. AIX

got a dumb question where do i get AIX 5.3 from

Guys, ive been looking about , but obviously not hard enough, Where do i get AIX 5.3 from ? DO i need to purchase it or is it free to download on a single user license ?:confused: Thanks (2 Replies)
Discussion started by: wmccull
2 Replies

6. AIX

AIX Virtualization question for non-AIX user

Hello, My first post to the Unix forums, thanks for having me! The division of the company I work for uses a xseries/redhat/VMWareServer solution to make sure that we keep hardware overhead low and use our machines to as near capacity as we can. These boxes are Intel with usually dual or... (1 Reply)
Discussion started by: greenteabagger
1 Replies

7. UNIX for Dummies Questions & Answers

AIX Question

What does it mean when a file has non-root ownership? (1 Reply)
Discussion started by: danielssk
1 Replies

8. UNIX for Advanced & Expert Users

aix's question

hi all, i'm really new to the aix system and i need ur help currently the home directory(/dev/hd1) is full, and i need to add more space to it from /dev/lv03. How do i do it?..can you show me step by step thankx (1 Reply)
Discussion started by: ichiro
1 Replies

9. UNIX for Advanced & Expert Users

AIX Question

Does anyone know of an AIX command that gets cpu type, speed and number of processors? TIA -mk (2 Replies)
Discussion started by: mikek147
2 Replies
Login or Register to Ask a Question
rpld-tools(1)						 System User's Manual: rpld-tools					     rpld-tools(1)

NAME
rpld-tools - RoarAudio PlayList Daemon control programs SYNOPSIS
rpld-next --ifcurple PLE rpld-ctl [COMMON OPTIONS] COMMAND [arg] rpld-queueple [COMMON OPTIONS] [--pos {first|last|POS]] PLE [PLI] rpld-listq [COMMON OPTIONS] [PLI] rpld-setpointer [COMMON OPTIONS] POINTER PLE [PLI] rpld-listplaylists [COMMON OPTIONS] [{--tree|--flat}] rpld-import [COMMON OPTIONS] PLI TYPE FILE DESCRIPTION
The RoarAudio PlayList Daemon is a daemon which manages playlists and can play files or streams from those lists using a RoarAudio Sound Server. This is a set of Perl based tools to do simple control of the server. The following tools are supported: rpld-next --ifcurple PLE Skip current song. if --ifcurple and a PLE is given the song is only skiped if the currently played song matches the given PLE. rpld-ctl [COMMON OPTIONS] COMMAND [arg] This command can alter diffrent parts of the current rpld state. This included playback state as well as some playlist manipula- tion. Possible commands are: pause Pause playback. unpause Unpause playback. togglepause If playback is paused unpause, if not pause. volume VOL Set volume to VOL. VOL must be in range 0%..100% or 0..65535. play Start playback. stop Stop playback. next Play next track. prev Play previous track. store Save current state to store. addplaylist PLAYLIST Add a new playlist. delplaylist PLAYLIST Delete a playlist. rpld-queueple [COMMON OPTIONS] [--pos {first|last|POS]] PLE [PLI] Queue the song PLE form playlist PLI. If no playlist is given all playlists are searched. A position where to queue to can option- aly be given. rpld-listq [COMMON OPTIONS] [PLI] List content of queue or given playlist PLI. rpld-setpointer [COMMON OPTIONS] POINTER PLE [PLI] Set pointer POINTER to a given target PLE. If no playlist (PLI) is given Main Queue is used. rpld-listplaylists [COMMON OPTIONS] [{--tree|--flat}] List all known playlists. Listing is done in correct tree view (default) or as flat view. rpld-import [COMMON OPTIONS] PLI TYPE FILE Import a playlist file FILE into a playlist PLI. The type of the file is given as TYPE. COMMON OPTIONS
The following common options are supported: --help THis option shows a brief help. --server SERVER This option sets the server to connect to. This overrides the defaults. --queue QUEUE This sets the default queue for the current process. SEE ALSO
rpld-deprecated(1), rpld(7), RoarAudio(7). HISTORY
For history information see RoarAudio(7). rpld-tools May 2012 rpld-tools(1)