SYSPROC.DB2LOAD

Sathyaram Sannasi

Environment: DB2 V8.2 on AIX

I find a SP SYSPROC.DB2LOAD for loading a table using cursors ... I
have tried to use the procedure and it seems to work as I want it to
.... But, I am unable to find any documentation for the procedure ..
Can someone let me know if it is advisable to use this procedure in an
application code and whether IBM supports ths use of the procedure ..

TIA

Sathyaram

Nov 12 '05 #1

Subscribe Post Reply

3765

arimpault

I've tried to use the procedure SYSPROC.DB2LOAD too and I didn't find
any documentation on it either. And i'm not able to make it work.
Can you tell me the arguments you used to make it work?

Thanks
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com

Nov 12 '05 #2

Sathyaram Sannasi

On contacting IBM, we were told that the procedure can be used but is
provided as-is without any support ... Seems the intention is to
support the procedure in V9

I have the details you ask for at my work ... Will post tomorrow

Cheers
Sathyaram

Nov 12 '05 #3

by: Andy S. | last post by:

Hi, I'm running DB2 v 7.2 FP 9. After connecting to DB2, i ran the following commands: set path = "SYSIBM","SYSFUN","DB2ADMIN","SYSPROC" SELECT * FROM TABLE(SYSPROC.ENV_GET_INST_INFO())...

DB2 Database

Stored procedures in SYSPROC schema

by: efiryago | last post by:

Are stored procedures in SYSPROC schema documented and supportedd? I am particularly intersted in the procedure SYSPROC.DB2LOAD which seems to be a SQL wrapper to the db2 load API. If that is true,...

DB2 Database

Can not run DB2LOAD in parallel

by: nekiv90 | last post by:

Greetings, We need to initial load hundreds of tables from within programs. We try to run several programs that call the DB2LOAD in parallel (to load different tables of course) in order to...

DB2 Database

Calling SYSPROC.DB2LOAD within SQL stored procedure

by: UDBDBA | last post by:

Hi: How can one call SYSPROC.DB2LOAD procedure within a SQL stored procedure. I get the following error: DB21034E The command was processed as an SQL statement because it was not a valid...

DB2 Database

SYSPROC.DB2LOAD

by: Suresh | last post by:

Hi All I am tring to call SYSPROC.DB2LOAD stored procedure from DB2 UDB 8.2. Command editor. i used the follwoing syntax... CALL DB2LOAD (1,NULL,'LOAD CLIENT FROM...

DB2 Database

Error in executing SYSPROC.ALTOBJ procedure

by: db2adm1 | last post by:

I am getting the following error while trying to alter a table's column...I am trying to increase the decimal length of the column from 5 to 6 using altobj procedure. SQL0443N Routine...

DB2 Database

db2Load API in C#

by: anils | last post by:

I am trying to implement db2Load in C#, using PInvoke looking at the sample C programe which has Dbconn() & db2Load() methods I could find db2Load in db2app.dll, I could not find Dbconn()...

DB2 Database

SYSPROC.ADMIN_CMD

by: chettiar | last post by:

I am trying to do the following from within a procedure. set vcsql = 'Call SYSPROC.ADMIN_CMD(' || '''load from /dev/null of del replace into bi.Provisioned_Spam''' || ')'; execute immediate...

DB2 Database

db2load remote database

by: Vivek | last post by:

Hi, I want to know if it is possible to load(using the db2load API) into a remote database. By remote database i mean one that i have cataloged. Any parameters that need to be changed ? TIA

DB2 Database

sysproc.snapshot_tbreorg

by: Roger | last post by:

For some reason when i execute this : select table_name from table(sysproc.snapshot_tbreorg('',-1))as t I doesn't return any data on couple of databases, but works on others, yet when I do list...

DB2 Database

Steps manually installing IntelliJ IDEA.

by: erikbower65 | last post by:

Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...

General

How to insert a new record in a database

by: Taofi | last post by:

I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...

DB2 Database

Cancel Print Action if Sub form has No Records

by: DJRhino1175 | last post by:

When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...

Microsoft Access / VBA

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

To verify entry of a dropdown

by: DJRhino | last post by:

Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...

Microsoft Access / VBA

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development

How does React native implement an English player?

by: lllomh | last post by:

How does React native implement an English player?

Mobile Development

How to calculate date of retirement from date of birth

by: Mushico | last post by:

How to calculate date of retirement from date of birth

Data Management

Windows 11 and Access Combo Box Issue

by: DJRhino | last post by:

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

Microsoft Access / VBA

Similar topics