ca.portal.admin

Re: IDMS SQL DML related question

Discussion created by ca.portal.admin on Dec 3, 2007
Hi Charles:

If you have the IDMS SQL option, and if you've created an SQL schema for
your network schema, you could update the database with the following
SQL
query:

UPDATE table1
SET CUSTOMER_STATUS = 'D'
WHERE (CODE_TABLE = 'E' AND
CUSTOMER_STATUS = 'R');

If you don't have the SQL option, you won't be able to use SQL against
the database.

However, you do indicate you have DMLO. You could write a DMLO CLIST to
loop through the database and do the updates. Please refer to the IDMS
DML Online documentation or use HELP during a DMLO session.

Hope this helps!

Regards,

Tom Schoenborn
TA Schoenborn & Associates LLC


----- Original Message -----
From: ""Charles Pereira"" <Charles.Pereira@FALCONJET.COM>
To: <IDMS-L@LISTSERV.IUASSN.COM>
Sent: Monday, December 03, 2007 2:41 PM
Subject: IDMS SQL DML related question


Hi,
I am pretty new to IDMS world and I have a question. Can IDMSBCF
through JCL allow me to do multiple row updates in a given record? If so
would there be any cons to this method of update multiple rows? Our shop
uses DMLO and other online tools. It seems they only use COBOL programs
to do such updates otherwise it is DMLO (one by one).

The update query is of the following form:
Loop through all the Table1 records ##If the field CODE-TABLE= 'E' then
If the field CUSTOMER-STATUS = 'R ' then Set the field CUSTOMER-STATUS
to 'D '


Thanks,
Charles Pereira
DFJ.
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: IDMS SQL DML related question
"Good explaination from Tom. One thing to watch out for is that no
commits are done during the entire update. If there are a large number
of record occurrances, this can cause various problems such as locking
all the records for a long time, or filling up the journals. You can
avoid these problems by running BCF in local mode. As for any local
mode update, be sure to get a backup first!

Outcomes