arrrrghhhhh! Learning a new syntax is a PAIN!
If it exists ... I need to DROP table QTEMP.ITEMS ... otherwise DECLARE GLOBAL TEMPORARY TABLE fails
I've found several discussions about th...
I have the following Table/field layouts and I would like to Import the data from two (2) IBM DB2 Tables to five (5) SQL 2005 Tables.
I'm not even sure how I would start to write the code for...
Hi,
when i execute the following procedure somehow it is deleting all the rows in the table.
Could someone please tell me what's is going wrong. er_no is defined as varchar(8) in database, s...
Hi Experts,
Iam using DB2 Universal Database V 8.1.2. I have a table XYZ with two columns 'Remote_Date' and 'Local_Date'. I want a select query as required, If 'Remote_Date' is not null i w...
Hi,
I am using DB2 and the OS is Solaris 10 (2.10) ksh shell, I need a two shell scripts one to drop all the indexes and then one to re-create them. I don't have the specifics of the tabl...
I have recently inherited a .NET application and for one of the screens it connects with a db2 system.
However, sporadically I get the following error while trying to open a connection to t...
hi,
how can i get ride of white spaces both sides i guess trim dont work in db2 8.2?
In db2 how can i see the db2 history log,, by code or in the control center,,,,,,,
i mean, if i do 3 inserts to de database and 5 uptades,,, how can i see this log,,, and when a trigger has b...
hi there,
getting error below while running procedure via command editor, Anu idea whats wrong?
------------------------------ Commands Entered ------------------------------
CREATE PROCE...
I need to replicate data from an AS400/iSeries to SQL Server 2005. How can we do this? Can anyone recommend a product that might be able to do this?
Can someone explain P1: & P2: to me? (or maybe point me at a BONEHEAD doc?)
I found a StoredProc sample using a GLOBAL TEMPORARY TABLE and a CURSOR ... It uses P1: and P2: ..... My StoredPr...
I am running two SQLs on db2 & they are giving no records found matching the selection criteria individually but when I run them after joining them with "UNION", the whole SQL starts returning...
----------------------------------------------------------
I've created a FUNCTION
----------------------------------------------------------
CREATE FUNCTION MYLIB.ZERODIVOK (
A INTEG...
I want to be able to pull data from Two (2) tables each, on three different Systems/Instance/DatabaseName. Is this possible or do I have to use a statement like in SQL, i.e. USE Database name....
Can someone give me an example of using SQLFetchScroll in a Srored Proceedure?
I would like to feed them 50 rows at a time.
Thanks
CREATE PROCEDURE Emdec_MainFlts ( IN RR1 VARCHAR(5),...
Need a query in DB2, to dump a table data into 2 different tables. Please help.
I want to use DB2 Express-C 9.5 as a backend with my .NET desktop applications. I am using this on a desktop application because I want to see how this RDBMS works and performs.
I have few ...
Apparently AS400 iSeries SQL R5V3 does not support data types BIT nor BOOLEAN ...
How do y'all declare and use a YES/NO, TRUE/FALSE value in a Stored Proc?
Example please?
@Kent
I already asked this in question ID: 23920460, but the answer deserves points :)
can you shortly tell me what a cube is or send me a link with a clear explanation.
Googeling I see ...
Over the years, in debugging code, I've often resorted to sprinkling things like printf(), response.write() and show() so I can "see" the value of local variables when the code actually runs. ...
Arrrrrggggghhhh!
Everytime I cut-n-paste code from
iSeries Navigator (Run SQL Scripts),
Windows Notepad,
SQL Server's Query Window,
WinSQL's Query Window
The Carri...
Where is the documentation on DB2 9.5 located? I want to learn the internals of it.
Anyway to see the "Explain SQL" output on a VIEW?
Often, simply "seeing" how somone else creates something, can be VERY EDUCATIONAL ...
So ... where can I find actual working samples of AS400 iSeries R5V3 SQL for UDFs, Procs, Views?
danged if I can NOT figure this out ...
Here's a nested if statement right from the DB2 SAMPLES ...
IF (v_salary < 2000 * v_years)
THEN UPDATE staff
SET salary = 21...
