ca.portal.admin

Re: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
"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
"shouldn't you be asking Carla?

At 04:41 PM 12/3/2007, you wrote:
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.
This is Chris Hoelscher and I approved this email
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
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: CA User Group Web Site
"I also had trouble registering.
I went to the address Gary suggested and got red carpet treatment on my
problem.
I'm all set now.

Thanks.
Jon Gocher


----- Original Message -----
From: ""Cherlet, Gary (JTS)"" <Cherlet.Gary@SAUGOV.SA.GOV.AU>
To: <IDMS-L@LISTSERV.IUASSN.COM>
Sent: Wednesday, November 28, 2007 10:32 PM
Subject: Re: CA User Group Web Site


Any problems registering for a CA User Group should be directed to CA at the
following e-mail address:

customerprograms@ca.com

HTH - cheers - Gary

Ps: I successfully registered today with no problems

Outcomes