|
|
Browse by Tags
- 9.1
- aix
- alter
- as400
- asp
- backup
- between
- blob
- case
- change
- check
- clob
- column
- command
- commit
- connect
- connection
- control
- convert
- create
- cursor
- data
- database
- date
- deadlock
- decimal
- delete
- download
- driver
- empty
- equivalent
- error
- export
- file
- format
- from
- function
- functions
- how
- IBM
- identity
- import
- insert
- iseries
- JAVA
- jdbc
- join
- key
- linked
- linked server
- list
- load
- lock
- log
- logging
- loop
- move
- null
- number
- odbc
- oracle
- performance
- procedure
- query
- REORG
- replication
- restore
- rows
- runstats
- schema
- script
- select
- server
- service
- shell
- size
- sql
- sql server
- sqlstate
- statement
- stored
- string
- syntax
- table
- tables
- tablespace
- temporary
- time
- timestamp
- transaction
- trigger
- udb
- update
- user
- v8
- VARCHAR
- variable
- variables
- vs
- websphere
-
How to test a Stored Procedure in DB2?
Hi, I'm developing in DB2 and has been troubleshooting a couple of Stored Procedures.. But i want to just run the SQL to be able to tweak it a little and see if that gets me the desired results.. Now, trouble comes when there are some local variables, defined in the procedure, or some global temporary... -
DB2 - Select x number of rows
How can I limit a select statement to x numbers of rows returned. If this was Oracle I could say select * from my_table where ROWNUM to get the first 49 rows. I want to do the same thing with DB2. -
Writing a case staetment in WHERE clause in Db2
WHERE DATE(LPAY.ADDED_DT) between date( '07' || '-' || '01' || '-' || CHAR(YEAR(current date ))) and (((DATE(current date) - Day(DATE(current date)) day)+1 day)) - 1 day Above is my where clause which works fine, I alwuas wants to get data from July to June and chnages... -
DB2 Load from cursor
Can prepared stmt be used for loading from cursor in DB2 9.1 LUW DECLARE CURSOR_NAME CURSOR WITH RETURN FOR V_DYNAMIC; PREPARE V_DYNAMIC FROM SQL_STATEMENT; OPEN CARRIER_CUR; Load Statement thanks -
How do I correct this: Error during SQL execution: (DA0003): [Exception: DBD, [IBM][CLI Driver][DB2/LINUX] SQL1218N There are no pages currently available in bufferpool
Hi all, My environment is DB2 UDBv8.1 Fixpak 16 on a RedHat Linux OS. I have tried to resolve this by trippling my default and 4K bufferpools size from 1000 to 3000 and I am still getting the SQL1812N error. I am desperate to solve this problem because very critical applications/reports depend on this... -
running multiple sql statements in iSeries Access for the web (ibm db2)
I am taking a class that uses this really crappy IBM online interface for us to run sql scripts in. I'm trying to figure out how to run multiple statements in a single run... example drop table tableA; drop table tableB; whenever I try to use " ; " in the statements it gives me an error... -
DB2 Stored Procedure - Current date with conversion
Hi, I am calling a stored procedure created in DB2. The stored procedure takes 1 parameter which is a date. The accepted type is a string and the accepted format is 'yyyymmdd'. I am trying to pass the current date for both parameters, but the conversion doesn't seem to work in the call of... -
How do i convert DB2 dates in SAS
Hi I am trying to construct a PROC SQL query in SAS where I have to join two tables with dates in them: Table1 has the column MyDate1 which is formated as Datetime25.6 and the values are of the form 31JAN09:23:58:01.000001 Table2 has the column MyDate2 which is formated as text $32. and the values are... -
DB2 UDB V6 import delimiters
Is there a way to specify a column delimiter other than the few in the pulldown option box when importing data into a db2 table? (Specifically a '~') Also, is it possible to import data into a db2 table without any type of character string delimiters? (The drop down box does not allow for a "none"... -
VSAM,Flat Files & Mainframe DB2 to ASCII Data Text Files with delimiters
Hi, My source data are in VSAM,Flat Files & Mainframe DB2.I need to port the data into informix running on AIX unix.If the data file is with delimetrs like "pipe" ,using "dbload" utility i can upload the data into informix database.I need the stpes or technique to convert the...