12-27-2013
Well, no point in bothering the web server for the batch, normally. PERL can talk to RDBMS as a client, running a query per record. Mapped in files are virtually inside the DB engine, allowing them to be worked in SQL and efficiently related to other tables inside a single, big query. Google "INFORMIX external file as table", and voila:
Using data file abstraction with external tables in Informix Dynamic Server- You want to write a query that goes through the file one time relating records to a join of db tables, and returns a cursor of augmented data to your client. You need a robust client setup, not something dopey like some odbc/jdbc cursors that query all the result into VM first so you can walk backward, forward, etc. You need a non-reversible cursor that just flows the data out through your client code immediately as it arrives.
Last edited by DGPickett; 12-27-2013 at 01:28 PM..
9 More Discussions You Might Find Interesting
1. Filesystems, Disks and Memory
Hi all,
Have two SCO 5.0.5 systems and one Slackware(joy?) system.
I've been asked to backup all three systems onto a newly acquired AIT Tape drive that we've installed on one of the SCO boxes.
Using the existing cpio backup script on the one SCO works a treat and is really fast (which is... (2 Replies)
Discussion started by: Cameron
2 Replies
2. UNIX for Dummies Questions & Answers
All,
Have an AMD-K6/2 PC, 20G.Hd along with RH7.2.
Wanting to know what I should do in terms of setup (workstation/server) and then what I can do with it?
I'd like to learn a DBMS and SQL - can I do this using RedHat?
Any suggestions with how I can use/ what I can do with this appreciated. (3 Replies)
Discussion started by: Cameron
3 Replies
3. UNIX for Dummies Questions & Answers
The current backup procedure we using a tar command in linux.
The files are stored in one partition in different folders. The docs stores in day wise folders like ex: /usr/data/xyz/20050129, /usr/data/xyz/20050130 .............etc
We using tar & gzip command to take backup everyday. The backup... (3 Replies)
Discussion started by: bache_gowda
3 Replies
4. UNIX for Advanced & Expert Users
We run WebSphere and by default it wants to install everything under /usr. While I can understand the default (everyone has a /usr) I would like to move this over to a dedicated volume group called apps and then setup my lv's and fs's here. Our WebSphere Admin doesn't like this because apparently... (1 Reply)
Discussion started by: scottsl
1 Replies
5. Shell Programming and Scripting
Hi,
I have written a script which calls a process which ends up in a reboot of the system. At the end of the reboot it prompts for login & i need to provide the login details. am not able to figure out hw to do this.
Doubt: will echoing login details after calling the process work?
for ex:... (1 Reply)
Discussion started by: meera
1 Replies
6. Solaris
Hi All,
we have an application that is written in 'C' programming to connects to various servers in the organization.
The bellow code establish a TCP connection to connect to the remote servers. the application works perfectly ok, but, after some time the entire process get's crashed and... (2 Replies)
Discussion started by: sudharma
2 Replies
7. UNIX for Advanced & Expert Users
Hello there....i am a final year comp science student.......i am thinking of doing my project on unix platform......which one do u suggest?thanx in advance... (3 Replies)
Discussion started by: theprasad1990
3 Replies
8. Solaris
I've been busy and fell behind on Sun/Oracle. Forgive me if too basic. I welcome brief, cryptic, or advanced replies. I also welcome noobie information since I may have no clue what's up at the moment.
Problem statement:
I inherited a computer to set up. I would rather not figure out 8 months... (1 Reply)
Discussion started by: Nevyn
1 Replies
9. UNIX for Dummies Questions & Answers
Hi guys, i'm undergoing a traning in solaris administration and i request if any one have an idea on the interview questions on solaris.
thank you. (3 Replies)
Discussion started by: 038karthik
3 Replies
LEARN ABOUT OPENSOLARIS
vino-server
vino-server(1) User Commands vino-server(1)
NAME
vino-server - remote desktop server
SYNOPSIS
vino-server
DESCRIPTION
vino-server is a remote desktop server based on VNC protocol. vino-server provides remote desktop takeover and remote desktop view func-
tions. vino-server allows multiple client to access a GNOME desktop session remotely. It is based on the VNC technology. vino-server pro-
vides service at port 5800. Each desktop has a vino server which disabled by default and a Java client application which is made available
to a client via a web browser (via port 5900 of the server machine is the service is enabled by the user).
FILES
The following files are used by this application:
/usr/lib/vino-server
The executable file for the vino server application.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWgnome-remote-desktop |
+-----------------------------+-----------------------------+
|Interface stability |Volatile |
+-----------------------------+-----------------------------+
SEE ALSO
vino-passwd(1), vino-preferences(1), attributes(5)
NOTES
Written by Steven Zhang, Sun Microsystems Inc., 2006.
Updated by Halton Huo, Sun Microsystems Inc., 2008.
SunOS 5.11 15 Aug 2008 vino-server(1)