Re: SQL Replication

2023-08-11 Thread John Abell
Would you explain what the source and target databases are please?

John T. Abell   
Tel:800-295-7608Option 4
President 
International:  1-416-593-5578  Option 4
E-mail:  john.ab...@intnlsoftwareproducts.com
Fax:800-295-7609

International:  1-416-593-5579


International Software Products
www.ispinfo.com


This email may contain confidential and privileged material for the sole use of 
the intended recipient(s). Any review, use, retention, distribution or 
disclosure by others is strictly prohibited. If you are not the intended 
recipient (or authorized to receive on behalf of the named recipient), please 
contact the sender by reply email and delete all copies of this message. 
Also,email is susceptible to data corruption, interception, 
tampering, unauthorized amendment and viruses. We only send and receive emails 
on the basis that we are not liable for any such corruption, interception, 
tampering, amendment or viruses or any consequence thereof.



-Original Message-
From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf 
Of Galdamez, Adolfo@EDD
Sent: Friday, August 11, 2023 3:24 PM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: SQL Replication

I just got a new assignment SQL REPLICATION.
Does anybody know an expert in the subject?
A checklist of what I should know?

From: IBM Mainframe Discussion List  On Behalf Of Ron 
Thomas
Sent: Friday, August 11, 2023 11:40 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Dfsort Overlay error

Hi Kolusu - Here is what i am getting . Could you please let me what changes to 
be made ? ICE000I 1 - CONTROL STATEMENTS FOR 5650-ZOS, Z/OS DFSORT V2R4 - 13: 
36 ON FRI AU OPTION COPY OUTREC 
IFTHEN=(WHEN=(35,10,CH,EQ,X'',
ZjQcmQRYFpfptBannerStart
THIS EMAIL ORIGINATED FROM OUTSIDE OF YOUR ORGANIZATION DO NOT click on links 
or open attachments unless you recognize and/or trust the SENDER.
ZjQcmQRYFpfptBannerEnd

Hi Kolusu -



Here is what i am getting . Could you please let me what changes to be made ?



ICE000I 1 - CONTROL STATEMENTS FOR 5650-ZOS, Z/OS DFSORT V2R4  - 13:36 ON FRI AU

   OPTION COPY

   OUTREC IFTHEN=(WHEN=(35,10,CH,EQ,X'',

AND,25,10,CH,GT,X''),

   OVERLAY=(35:25,10,TOGREG=Y4T(-),ADDDAYS,+120,TOGREG=Y4T(-)))

 $

ICE007A E SYNTAX ERROR

ICE751I 0 C5-I79518 C6-I90068 C7-I76949 C8-I75151 E7-I76949

ICE052I 3 END OF DFSORT



Thanks

Ron T



--

For IBM-MAIN subscribe / signoff / archive access instructions,

send email to lists...@listserv.ua.edu<mailto:lists...@listserv.ua.edu> with 
the message: INFO IBM-MAIN

--
For IBM-MAIN subscribe / signoff / archive access instructions, send email to 
lists...@listserv.ua.edu with the message: INFO IBM-MAIN

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN


SQL Replication

2023-08-11 Thread Galdamez, Adolfo@EDD
I just got a new assignment SQL REPLICATION.
Does anybody know an expert in the subject?
A checklist of what I should know?

From: IBM Mainframe Discussion List  On Behalf Of Ron 
Thomas
Sent: Friday, August 11, 2023 11:40 AM
To: IBM-MAIN@LISTSERV.UA.EDU
Subject: Re: Dfsort Overlay error

Hi Kolusu - Here is what i am getting . Could you please let me what changes to 
be made ? ICE000I 1 - CONTROL STATEMENTS FOR 5650-ZOS, Z/OS DFSORT V2R4 - 13: 
36 ON FRI AU OPTION COPY OUTREC 
IFTHEN=(WHEN=(35,10,CH,EQ,X'',
ZjQcmQRYFpfptBannerStart
THIS EMAIL ORIGINATED FROM OUTSIDE OF YOUR ORGANIZATION
DO NOT click on links or open attachments unless you recognize and/or trust the 
SENDER.
ZjQcmQRYFpfptBannerEnd

Hi Kolusu -



Here is what i am getting . Could you please let me what changes to be made ?



ICE000I 1 - CONTROL STATEMENTS FOR 5650-ZOS, Z/OS DFSORT V2R4  - 13:36 ON FRI AU

   OPTION COPY

   OUTREC IFTHEN=(WHEN=(35,10,CH,EQ,X'',

AND,25,10,CH,GT,X''),

   OVERLAY=(35:25,10,TOGREG=Y4T(-),ADDDAYS,+120,TOGREG=Y4T(-)))

 $

ICE007A E SYNTAX ERROR

ICE751I 0 C5-I79518 C6-I90068 C7-I76949 C8-I75151 E7-I76949

ICE052I 3 END OF DFSORT



Thanks

Ron T



--

For IBM-MAIN subscribe / signoff / archive access instructions,

send email to lists...@listserv.ua.edu<mailto:lists...@listserv.ua.edu> with 
the message: INFO IBM-MAIN

--
For IBM-MAIN subscribe / signoff / archive access instructions,
send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN