Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB SQL Option * Time: hh.mm.ss * DBSQLPR SQL Processor * Version: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** Command Line Options ___________________ INPUTWIDTH=72 OPTFILE=OP PRTWIDTH=999 Option File Options ___________________ AUTHID=SYSADM INPUT STATEMENT: create table testTable (colChar char(18), colInt integer); ___ SQLCODE=0, SQLSTATE=00000 ___ INPUT STATEMENT: insert into testTable values ('colChar row 1', 1); ___ SQLCODE=0, SQLSTATE=00000, ROWS AFFECTED=1 ___ INPUT STATEMENT: insert into testTable values ('colChar row 2', 2); ___ SQLCODE=0, SQLSTATE=00000, ROWS AFFECTED=1 ___ -- Output appears as a table unless "PRTWIDTH=" is exceeded. INPUT STATEMENT: select colChar, colInt from testTable; COLCHAR COLINT CHAR(18) INT ___________________ ____________ colChar row 1 1 colChar row 2 2 ___ 2 rows returned ___ INPUT STATEMENT: rollback work; ___ SQLCODE=0, SQLSTATE=00000 ___
Date: mm/dd/ccyy ******************************************************************************** Page: 1 * CA Datacom/DB SQL Option * Time: hh.mm.ss * DBSQLPR SQL Processor * Version: 12 * Copyright © 2009 CA. All rights reserved. * SPnn ******************************************************************************** ================================================= == DBSQLPR is completing with return code 0000 == == == == Statements Found: 00005 == == Statement Errors: 00000 == == Statement Warnings: 00000 == =================================================
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|