472,791 Members | 1,841 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,791 software developers and data experts.


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 ..



Nov 12 '05 #1
2 3765
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?

Posted Via Usenet.com Premium Usenet Newsgroup Services
Nov 12 '05 #2
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


Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

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())...
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,...
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...
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...
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...
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...
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()...
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...
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
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...
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...
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 ...
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...
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...
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...
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=()=>{
by: lllomh | last post by:
How does React native implement an English player?
by: Mushico | last post by:
How to calculate date of retirement from date of birth
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.