I am calling the EXEC SQL EXECUTE statement and passing in variables. However, i keep getting this error:
An unexpected token "EXEC SQL EXECUTE sql USING " was found
following "Year = ? + C...
Hi all,
Looking for anyone that might have a project plan in MS Project that they have used for a DB2 migration project!
I'm going to co-manage a project to migrate from a DB2 V7 to a DB2 V8...
We have a fairly sizable installation of DB2 on AIX (all new versions) and a data mart with a fact table of around 150 million records. Not that big. Hundreds of supporting tables. I run re...
We have a number of nested SP and Functions in our app. Whenever we want to update the logic of a SP, it looks like you have to DROP it first, then CREATE it.
The problem I have is with a s...
Hi,
How do you select variables using a select statement like you do in MS SQL?
For example:
select @month = month, @year = Year From tableXYZ
I want to know that if I don't have a backup of my database and I want to restore the database to another machine using the files in my existing machine, what is the procedure? Can I just copy...
I have a SQLSTMTSTR that has the entire SQL script and is built dynamically in the SQLRPGLEW program. Once the build is complete, I have to SCAN for the WILDCARD CHARS "???" and replace with...
i have created one .bat file in windows in my java code to perform db2 export .I want to know how can i achieve the same in as/400 from my java code.
when i select the function:
newFunction(select name, address from customer)
i want it return the result like:
name1,address1
name2,address2
count=2
Is a calculated field possible in AS400 iSeries V5R4 SQL ?
I can't find any documentation on "Calculated Field" is it called something else?
Like .... MyTable.FieldABCD = (MyTable.FieldA...
I'm using Navigator in an iSeries DB2 AS400 V5R3M0 environment.
Can an SQL Function declare and use a Global Temp Table?
DECLARE GLOBAL TEMPORARY TABLE ITEMS (ITM VARCHAR(50)) NOT LOGGED;
hi there ,
how can i delete duplicate rows
dmt_campaign_id
1008
1008
1008
1008
1007
1006
1005
1005
1008
1002
1006
i want it to be
1008
1007
1006
1005
1002
Hi Experts,
What is the alteranate of TOAD for DB2 which is a freeware. Iam not looking for control center.
Please help me out.
Thanks & Regards,
Rave.
Help!! I have been away from DB2 for a looooooooong time.
Here is the situation. I have function FUN1 (LANGUAGE SQL) that is called by a trigger TRIGG1.
I modified the code within FUN1...
This is a relatively simple query to a single table on DB2 (AS400 i5 system). I'm finding the basic data correctly, but can't quite pull off the subquery to get the single line totals. I've be...
I have an .ASP document I am writing in HTML-Kit. I'm connected to a db2 database. The language is VBSCRIPT.
I am calculating elapsed time for open tickets. The open_time is in GMT. I've c...
Is there a way to dynamically loop through a column extracting values on a pattern.
For ex:
Fiel1
123, zzz, 132, ddd, 125, rrr, 146, mmm ...... (Could be as long as 250 characters )
R...
Hi,
when i am creating any store procedures, i am getting error.
>[Error] Script lines: 1-15 -------------------------
DB2 SQL error: SQLCODE: -7032, SQLSTATE: 42904, SQLERRMC: CHK_CLA...
Below is the "Explain SQL" from an extremely SLOW stored proc.
I see:
SQL4010 Table scan access for table 1
How do I identify "Table 1"?
I also wonder about lines ... #55 and #93
...
I have a windows form that makes a SQL call to a DB2 database. I can successfully complete the test with simple SQL statements. However, my complex SQL statement is failing with this error: Me...
Some of my queries are real system hogs and I was wondering if there is a good way to restrict the amount of resources available to the query. I would rather have it run longer than slow every...
I ned to link two (2) - Tables each frm Different DB2 Systems. Is it possible to link these systems together? I'm new to DB2, so please be patient. I've heard of Federated Systems but wouldn't...
I need a WHERE clause to find
[A1]
[A12]
[A998]
[A1356]
[A87654]
but NOT
[AM]
[ALC]
[A2H4K8]
[B2987982]
[Z111111111]
Any idea's?
AS400 iSeries V5R4 SQL ....
Can't a "Global Temporary Table" be returned from a Stored Proc?
Or am I missing the "real" error?
What I got ...
CREATE PROCEDURE CSIDEV.DVLCHRT ( )
DYNAMIC RESULT SETS 1
...
I have some XML data in DB2 Express-C 9.5.
Table name is EMP. It has two columns ID integer & INFO xml.
xml data inserted in table is <employee><name>John</name></employee>
Now i want to...
