Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Fixpak 12 rollback.
Hello, I'm planning to apply Fixpak 12 on Win 2003 server with DB2 V8.1 Fixpak 7a. Does anyone know if there are any documentation on rolling back Fixpak 12? I was told that there is an option to 'not commit', but I haven't seen the documentation. Any help would be greatly appreciated... -
How to remove a task from the Task Center?
Hello, I created backup jobs that dump the backups from WINNT to a Sun box through a WINNT mapping using Samba. I used the Task Center to schedule the backup jobs using the OS command script type. All the backups ran fine with the exception of one which I forgot to specify the folder name in... -
XML Extender
hello, i am trying to enable the XML extender by running the following command: dxxadm enable_db DATABASE; but i keep getting the following error: SQL0104N An unexpected token "enable_db" was found following "dxxadm ". Expected tokens may include: "JOIN... -
How do you trap Sybase ASE 11.9.2 SP output into a variable?
hello, i wrote a perl script which calls a stored procedure based on a parameter using sybperl.pl... i would like to capture the output in a variable which Sybase returns... not what perl/unix returns... is this possible? i can not find any sybperl documentation or sybase open client/server... -
regex for breaking up one column unix file into three columns...
hello, i'm trying to break up a unix file with the following sample data into three columns: 16:42:33.02 16:42:36.37 16:42:46.50 16:42:49.83 16:43:00.08 16:43:03.79 the original file contained other data, but i was mainly interested with these times...so i initially passed through an array... -
sql for producing same product_name with unique product_id.
querying against a product table. what's the best way to produce an output with all the records that have the same product_name but have different product_id_number's? product_id_number is the primary key for the product table. i am trying to just collect all the product_id_number's from the query.- qyllr
- Thread
- Replies: 3
- Forum: Sybase: Adaptive (SQL) Server
-
re: sql output header printing question.
the sql output contains headers for each row returned from a query. sometimes these headers do not appear on the top of the query result-they appear in the middle. The following is the header print section of the script I wrote: # PRINT THE FIRST 2 LINE # OPEN REPORT FOR READING open...
