Messages

31

Report Indexing / Re: BREAK=YES creates multiple documents but no split happens

« on: May 08, 2019, 11:02:51 AM »

For a quick check, make sure you're getting a top of form (X'F1') at the top of every page.  Your symptoms are similar to that issue.

32

Other / Re: Unable To Sort Columns

« on: April 08, 2019, 05:23:37 AM »

Check Options: Document List Mode and make sure it's Spreadsheet and not listbox

33

z/OS Server / Re: ODF justification

« on: February 25, 2019, 07:20:44 AM »

Reloading a report for various reason is our most "uncommon" use of ODF.  One example is a report that comes in in EBCDIC that some users want "as is".  We use ODF to reload a second copy that runs through an input exit that converts the doc to an ASCII based CSV file that other users can then import the file directly into an Excel spreadsheet.
 We also use the reload method keep both a raw version of the report and an AFP version of the same report per a request from the users.  I think it was a data verification thing which was easier done against the raw version.
 I don't think auto distribution lessens the workload on the server much as the distribution is a retrieval itself however it did make it easier on some units that, for whatever reason, didn't want/couldn't get access for some users to any version of the CMOD client.

34

MP Server / Re: Error running ARSXML export.

« on: February 13, 2019, 06:46:49 AM »

When we migrated from an 8.5 system (windows) to a 9.5 system(z/OS) I used ARSXML with a lot of manual manipulation of the xml export, including storage, to get the items to be defined correctly.  Seemed no way around it at the time.

35

z/OS Server / Re: ARS1143I Error Referencing field names with non standard characters

« on: February 01, 2019, 10:02:27 AM »

Your hex values are off.  Not sure how they were created but they need to be corrected for z/OS
eg.  Your RunDate is X'52756E44617465'  which, in EBCIDC, is êÍ>à/ÈÁ.
       It should be X'D9A495C481A385'

When you use the graphical indexer wizard be sure your sample is in EBCIDC and your code page is set correctly.

36

Report Indexing / Re: Do I need to provide Index parameters to load a simple report

« on: February 01, 2019, 09:57:23 AM »

You don't need a trigger. We also just have a basic index defined.  Can be anything.
Something like this:

CC=YES
CCTYPE=A
CONVERT=NO
CPGID=500
MCF2REF=CPCS
TRC=NO
FILEFORMAT=RECORD,256
FIELD1=X'C3C9C3E240C4C5C6C9D5C9E3C9D6D5E240D9D7E37A40D7C4C5E54040C7F8F6F3'
INDEX1=X'D985979699A36DD5819485',FIELD1,(TYPE=GROUP,BREAK=NO)     /* Report_Name  */
DCFPAGENAMES=NO
UNIQUEBNGS=YES
IMAGEOUT=ASIS
INDEXOBJ=ALL
INDEXSTARTBY=1
INSERTIMM=NO
RESTYPE=NONE

37

z/OS Server / Re: Running into OAM error RC08 40060303 when deleting Application Group

« on: November 13, 2018, 06:33:26 AM »

I've learned to trust OAM messages.  If it's telling you there is still an object out there for the application group then there likely still is.  This can happen for a number of reasons: OSMC not run/errors, ARSEXOAM not run/errors,...   Generally speaking deleting empty application groups shouldn't be difficult.  I would try to track down the what/why an object is still out there when you believe the AG should be empty.

38

Report Indexing / Re: POSTING DATE ISSUE

« on: October 31, 2018, 05:20:38 AM »

Did you try using a mask or regular expression for the date?  Assuming there is no other date is the same column elsewhere in the docs
Might be a little tricky coming up with a mask for that date format but if you're not on z/OS you could use a regular expression instead.

39

z/OS Server / Re: Too many tables in Appl. group

« on: September 26, 2018, 05:12:26 AM »

We've run into this as well and developed our own process to join tables.  One possible quick fix to keep things running until you correct the issue is to force users to use the field you designated as your segment field so your queries don't use all 260 segments.

40

Report Indexing / Re: Load from ARSDOC GET

« on: September 05, 2018, 12:39:03 PM »

I recall tricking the indexer into using the default value from the admin client by using another trigger on a constant in the field such as the ':' in the time eg 10:30.
The field was based off of that trigger.  If the trigger can't find the ':' it never checks the field and uses the default.

41

Report Indexing / Re: Load from ARSDOC GET

« on: September 05, 2018, 12:26:07 PM »

Did you use the 't' in the client or add the default parm to the indexing?
On multiplatform you can do the following to pull in a default date using regular expressions.
FIELD2=UL(0.00,1.82),LR(8.50,2.06),0,(TRIGGER=1,BASE=0,REGEX='[A-Z][a-z]+ [0-9]+, [0-9]{4}',DEFAULT='January 1, 1970')

We try to use something that makes it obvious it's a default value.

42

Report Indexing / Re: Load from ARSDOC GET

« on: September 05, 2018, 10:46:42 AM »

Did you try setting a default value for that last date/time index?

43

z/OS Server / Re: Can't get a trace file written

« on: July 23, 2018, 05:01:11 AM »

The only differences we have on our z/OS system is we have ÝTRACE¨ instead of [TRACE].  I know that was required versions ago, not sure if it's still relevant. We also don't have the TRACE_LEVELS= set in trace.settings.

44

z/OS Server / Re: z/OS V2.3 Release Notes

« on: July 11, 2018, 05:35:25 AM »

On our z/OS v9.5 system we find the SRVR_ODF_CFG parameter in ARS.INI
Ý@SRV@_OND14T¨
HOST=##.##.##>##
PROTOCOL=2
PORT=1446
SRVR_INSTANCE=OND14T
SRVR_INSTANCE_OWNER=OND14T
SRVR_OD_CFG=/etc/ond/ars14t.cfg
SRVR_SM_CFG=/etc/ond/14T/ars.cache
SRVR_OD_STASH=/etc/ond/ars14t.stash
SRVR_ODF_CFG=/etc/ond/arsodf14t.xml
Ý@SRV@_OND14P¨

45

z/OS Server / Re: CMOD Extraction of data

« on: July 03, 2018, 07:29:50 AM »

Truthfully JD's method is the proper supported way.  ARSDOC gets and stores is the most straightforward and less prone to errors. In my shop we are the CMOD Admins, System Programmers, and DBAs all in one so we tend to bend the rules a bit to get things done quicker and easier.