MVSFORUMS.com

Thanks papadi for suggesting me to contact someone of my scheduling people. From now I'll have no hesitation to use the phone. I just wantded to know the right syntax for doing it via batch by myself.

Hello,

I have Job-C which has a connection with Job-A and Job-B. Job-C is already on the Queue and is waiting. How can I modify (in batch mode)only for this run the connection so Job-C can go on ? ...

Hi expat,

Thanks a lot for your help. I resolved the problem sorting the input VB file for the length of the VSAM index so I didn't get another error.

Best regards
Denis

Hello to everyone,

I have a VB file and I need to copy it in a new VSAM (KSDS). The VB file has LRECL=3924 and the VSAM should be LRECL=3920. I tryed with the following but didn't worked.

//DELV ...

Thanks a lot for your prompt response kolusu, I tryed it with Y2T format and worked fine. Very helpful.

Best regards

Hello to everyone,

I tryed the following SORT card for selecting records wich are equivalent to TOD's date minus 7 days but didn't worked. Gives me nothing in Output. Can anyone help me out ? Thank ...

Thanks a lot kolusu for your prompt reply. I managed out by the way creating via IDCAMS a VSAM with same characteristics giving the parameter MODEL which bypassed the position and length of the KEY un ...

Hello to everyone,

Can anyone tell me how can I find the position and the length of a VSAM file ? I tryed IDCAMS command LISTCAT ENTRIES(TASV.CRAD0000.CRADSCAR) but gives me only the information th ...

Hello,

Thanks to everyone for their effort. I found the solution using SORT like this:

//COPYVSAM EXEC PGM=SORT,COND=(4,LE)
//* ...

Thanks a lot Mr.Brenholtz,

How can I set correctly RECSZ in order to have 924 byte variable record for SORTOUT which is now defined as RECSZ(15 25) ? Thank a lot for your time.

Best regards
Den ...

Hello,

I've tryed the following JCL for creating and copying into a VSAM file the content of another VSAM:

//VSAMDEF$ JOB 'A-ASSI-SPG-AS-C',REGION=0M,CLASS=4,MSGLEVEL=(1,1),
// ...

Hi edkir98,

Thanks for your clarification regarding GTT

I'forgot to ask if your table has any Primary Key or any CONSTRAINT ?

Hi edkir98,

I've alwas seen coded :CCSID EBCDIC for creating PLAN_TABLES to EXPLAIN SQL statements, not for CREATE-ing TABLES or TEMPORARY TABLES. Try again without CCSID EBCDIC specified and tell ...

Sorry I forgot the redefining items of MY-SQLVAR2:

10 MY-SQLVAR2 REDEFINES MY-SQLVAR1.
15 MY-SQLVAR2-RESERVED-1 PIC S9(9) BINARY.
...