[DB2-L] DSNTIAUL

Ruediger Kurtz

[DB2-L] DSNTIAUL
Yep, works:

DSNT490I SAMPLE DATA UNLOAD PROGRAM
DSNT505I DSNTIAUL OPTIONS USED: SQL
DSNT503I UNLOAD DATA SET SYSPUNCH RECORD LENGTH SET TO 80

INSERT INTO PS72.TASTUDIENGANG
VALUES ( 99 , 'MUSIK-WISSENSCHAFT' , 'LOW')
DSNT400I SQLCODE = 000, SUCCESSFUL EXECUTION
DSNT416I SQLERRD = 0 0 1 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000000' X'00000000' X'00000001' X'FFFFFFFF' X'00
INFORMATION

Ruediger

-----Ursprüngliche Nachricht-----
Von: DB2 Data Base Discussion List [mailto:[login to unmask email] Im Auftrag von [login to unmask email]
Gesendet: Dienstag, 12. Dezember 2006 15:13
An: [login to unmask email]
Betreff: Re: [DB2-L] DSNTIAUL

Yes, you can when you use PARM='SQL'.
From the sourcecode-documentation (member DSNTIAUL in SDSNSAMP lib):


* INPUT *
* SYMBOLIC LABEL/NAME = PARM *
* DESCRIPTION = PARAMETER FOR DESIGNATING INPUT TYPE. *
* IF THE VALUE 'SQL' IS SPECIFIED FOR THIS PARAMETER, *
* INPUT IS IN THE FORM OF COMPLETE SQL STATEMENTS *
* OF UP TO THE MAXIMUM LENGTH ALLOWED BY DB2. EACH SQL *
* STATEMENT MUST BE TERMINATED BY A SEMICOLON. *
* SYMBOLIC LABEL/NAME = SYSIN *
* DESCRIPTION = DDNAME OF SEQUENTIAL DATA SET CONTAINING *
* SQL STATEMENTS TO BE EXECUTED. *
* FOR FORMAT, SEE NOTES SECTION. *


regards gerhard


-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Tek-Hoe Tan
Sent: Tuesday, December 12, 2006 2:36 PM
To: [login to unmask email]
Subject: [DB2-L] DSNTIAUL


Can you use DSNTIAUL to perform insert, delete and update ?

Is there a documentation about it?

Thank you

Regards,
TekHoe Tan

------------------------------------------------------------------------
---------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that
page select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences
at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

James Campbell

Re: DSNTIAUL
(in response to Ruediger Kurtz)
Not only DML - but DDL as well. However I don't recommend (or to be more accurate "I
recommend not") using DSNTIAUL for creating views - at least not if there is anything after
the "create view" statement. SYSIBM.SYSVIEWS gets rather bloated.

James Campbell

(Yes JxC, this one's for you)

> -----Original Message-----
> From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
> Behalf Of Tek-Hoe Tan
> Sent: Tuesday, December 12, 2006 2:36 PM
> To: [login to unmask email]
> Subject: [DB2-L] DSNTIAUL
>
>
> Can you use DSNTIAUL to perform insert, delete and update ?
>
> Is there a documentation about it?
>
> Thank you
>
> Regards,
> TekHoe Tan
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm