I have checked the IBM support page for this error but it only mentions a VB solution (connect.nojournal=true). How do I perform the same function in C# please, (i.e. without journalling the t...
Hi,
I am trying to create a stored procedure in DB2 that does the following:
1)it checks if a table MYTABLE1 exists, and if it does, it drops that table
2)creates a new table MYTABLE
3)som...
Hi ,
I am getting following error in DB2 ver 7-
table space quiesced exclusively ..load pending ,Table space access denied
When i tried to load some sql and it interrupted during load. ...
Syntax help please ... AS400 iSeries SQL
NOTICE: we've upgraded from V5R3 to V5R4
Attempt to compile errors at line: DECLARE C1 CURSOR for
SQL State: 42601
Vendor Code: -104
Messag...
Hi: I need to concat a string "A:" or "B:" based on which column is being picked up in the case statement of the below SQL. My SQL looks like below:
Select T.col1, T.Col2,
case wh...
can a UNION ALL type construct be built into a Logical File?
How?
I must be missing some BASIC FOUNDATIONAL CONCEPT!
I'm working in iSeries Navigator against an AS400 DB2 V5R3M0
I'm logged into a database connection "CSISTEEL.COM"
I click "RUN AN SQ...
I have a DB2 table with 50,000,000 rows. Many of the fields are Varchar(60) and contain little or no data but have been padded with spaces to take the fill 60 places.
Can anyone think of a...
I need to do a database backup and restore from production DB to Disaster Recovery DB in weekly basis both are AIX Box. Can any one provide me the script which can take backup and restore it ...
I'm coding in Java, querying UDB (DB2). The SP returns three resultsets. The code I'm modifying uses a DBData object to store the result set. Now that I know there are multiple resultsets, I n...
What DB2 settings do I need to say to literally minimize to its minimum possible level the logging functionality? In other words how can I minimize logging in DB2 if not completely turn it off...
I'm working in SQL for AS400 iSeries V5R3 .
So, the only kind of Materialized Query Table I can build is one "MAINTAINED BY USER".
Meaning I must manually rebuild my table ...
So I have a...
This is a Ward transfer code, here is my servlet code, the last 4 queries are creating a weird problem and throwing up an exception when the queries has been done from the database itself. I'm...
The enclosed query is being executed on an AS400 by way of a query editor. The query was developed with help from EE, so I don't totally understand it all. It appears that all the columns retu...
With Oracle, SQL Server, MySQL and most other DBMS, I typically encounterone, maybe two instances (if the server is beefy) running on a single server. I've occasionally seen 3 or 4 in non-pro...
Ok, I'm just learning AS400 DB2 SQL syntax. I'm disappointed at the response speed of my FIRST two StoredProcs. Both operate against two different VIEWs.
Are VIEWS inherrently slow by their...
I'm having a hard time converting my MS SQL knowledge to AS400 iSeries SQL ..... sigh
Can someone please tell me how to do this ....
CREATE FUNCTION CSIDBT.YMD2DATE(PARAM1 INTEGER)
RETUR...
Hi Experts,
Iam using db2 data base. We have data base schema with us and accidentally i have removed it from the instance but it was not dropped. now iam trying to restore it back again. b...
hi there
any idea whats wrong with thos sql
UPDATE DMART_MKT2.DMT_TACTICS_FT_1 A SET DMT_OPPRTNTY_ID= SELECT
T10.DMT_OPPRTNTY_ID
FROM
(dmart_mkt1.STG_TACTICS T1 LEFT OUTER J...
How do I create a proc to return OUT values?
For example ... (this does NOT work) ... sigh
CREATE PROCEDURE MYSCHEMA.MYPROC
(
OUT vo1 numeric(4,2) ,
OUT vo2 numeric(4,3)
)
...
How do I create a fenced stored procedure. I tried adding FEnced just below create procedure. But it is giving me in valid syntax error. I am using SQL Stored procedure
using SQL for AS400 iSeries R5V3 ...
What is the easiest way to calculate the last-day of a particular month?
For Februray ...
for Feb'2008 that would be 02/29/2008? (a leap year)
but fo...
I'm using as400 SQL iSeries R5V4
I have a stored procedure.
Using an iSeries Navigator "Run SQL Scripts" window, I can write CALL MYLIB.MYPROC
and a record set is returned by the Stored...
How can I find counts on multiple tables all at once in db2 udb? It is time consuming to run statements individually.
Thank you.
When calling a db2 sql stored procedure from Zend Core php program nuneric values are passed and returned OK. Input or output character fields contain garabage characters. I think may have som...
