The last SQL was not valid, hence your person.lst file would be empty.
In the list of columns and expressions for the select statement, you have an extra comma.
That would make life a bit difficult for you....
Mondo Tofu
Last Activity: Jan 9 '07, 02:31 AM
Joined: Dec 10 '06
Location: Vacationland
-
fn:replace("a,b ,c,d,e",","," ")
if you don't like that approach you could always tokenize your input, then string-join it back together.
Good luck!Last edited by Mondo Tofu; Dec 10 '06, 07:59 PM. Reason: wrong text should have been a,b,c,d,e instead of 1,2,3,4,5Leave a comment:
-
The DECODE statement is equivalent to a number of IF THEN ELSEs or CASE statements.
Using a DECODE statement to solve the problem means that anytime that there's a change in a course title or description, you're going to be back to the task of mending the program logic.
What would be more resillient is to have your program basically act the same even though the data is changing, so creating a dataase table to assert...Leave a comment:
-
SELECT TBNAME, NAME FROM SYSIBM.SYSINDEX ES
GROUP BY TBNAME, NAME;
Good luck.
Mondo TofuLeave a comment:
-
With the wizards for installing DB2 for LUW, a lot of this can be done automatically by choosing the automatic management options.
It's really quite nice. Not so much fuss and trouble as setting up and administering an Oracle DB, in my opinion.
Mondo TofuLeave a comment:
-
What you typed in should work.
One thing to watch for in SQL*Plus is avoid putting blank lines in your anonymous PL/SQL block.
It could fool the interpreter and think that the code did not belong together.
As with all PL/SQL code, issue a slash ( / ) all by itself in the first column to execute the code.
Good luck!
Mondo TofuLeave a comment:
-
when creating a user, always specify the tablespace where the schema objects should be stored.
For example,
CREATE USER super IDENTIFIED BY super
DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp;
GRANT CONNECT, RESOURCE, UNLIMITED TABLESPACE to super;
When you connect to your user name (i.e. SUPER/SUPER), then you will have access to the USER tablespace and all your objects...Leave a comment:
-
You could read from a file where the usernames and passwords are stored.
Store the password file in a directory where only DBAs can get to.
That you read from a file to obtain a password will be obvious to the Unix sysadmin, but what you read from it does not need to be echoed in the logs.
Recommend that you make the passwords very long up to 30 characters, and very difficult to guess.Leave a comment:
-
I think that this works much the same.
SELECT MAX(a),
CASE WHEN b>=x THEN 'N' ELSE 'Y' END AS above_limit
FROM B
WHERE a<=CURRENT_DAT E
GROUP BY a,b
The only trouble I had was with x until I turned it into a constant.
If x varies a lot, you might consider writing a function so that you can pass x.
If x is handled via a SQL Procedure in DB2, then...Leave a comment:
-
connect / as sysdba
then provide the password for the sys account. This is a special mode for maintaining the database.Leave a comment:
No activity results to display
Leave a comment: