Re: XML Parse Errors
It's in the COBOL language reference manual - in one of the appendixes. ┌┐ │ Table 89. XML PARSE exceptions that allow continuation │ ├┬──┬┤ │ Code │ Description │ Parser action on continuation │ ├┼──┼┤ │ 1 │ The parser found an invalid │ The parser continues detecting errors │ ││ character while scanning white space │ until it reaches the end of the│ ││ outside element content. │ document or encounters an error that │ ││ │ does not allow continuation. The │ ││ │ parser does not signal any further │ ││ │ normal events, except for the │ ││ │ END-OF-DOCUMENT event. │ ├┼──┼┤ -Original Message- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Vince Smith Sent: 13 January 2009 15:43 To: IBM-MAIN@bama.ua.edu Subject: XML Parse Errors I am getting a XML CODE of 001 on a COBOL XML Parse statement. Can someone point me to the manuals that list all of the error codes that can be generated from the COBOL XML Parse statement? Thanks. Vince -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html This e-mail has come from Experian, the only business to have been twice named the UK's 'Business of the Year’ === Information in this e-mail and any attachments is confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient. Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. Companies Act information: Registered name: Experian Limited Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Place of registration: England and Wales Registered number: 653331 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: JCL Problem...
Is there any reason why you aren't pointing SYSPRINT (or whatever) at a temporary (or permanent) file, and using that file as the SYSIN dataset for STEP02? For what reason do you *need* the SYSIN data to be instream? -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Michael Knigge Sent: 22 October 2008 10:37 To: IBM-MAIN@BAMA.UA.EDU Subject: JCL Problem... All, I have a utility that outputs a string to SYSPRINT (but that can be changed). Now I need to pass this string via SYSIN (or PARM) together with some other parameters to a second utility. A little pseudo-sample: //* //* IMAGINE FOO WILL OUTPUT AN IP-ADDRESS - BUT THE ADDRESS //* IS OF COURSE NOT KNOWN... //* //STEP01 EXEC PGM=FOO //SYSPRINT DD SYSOUT=* //* //* NOW I NEED TO EXECUTE A COMMAND THAT CONTAINS //* THE IP-ADDRESS //STEP02 EXEC PGM=BA,PARM='PING the.ip.addr.here' . OR ... //STEP02 EXEC PGM=BA //SYSIN DD * PING the.ip.addr.here //SYSPRINT DD SYSOUT=* Any ideas how to solve this problem? My first idea was to pass the SYSPRINT from STEP01 to a following STEP that issues an EDIT-Macro that changes the contents to my needs (BTW, how to do this?). The new SYSPRINT is then passed to the PING STEP. Of yourse this is just simplified just to show you what I need. My real case has nothing to do with IP-Adresses and PING and that stuff, but this sample is (I think so) easy to understand... Thank you in advance Bye, Michael -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html This e-mail has come from Experian, the only business to have been twice named the UK's 'Business of the Year’ === Information in this e-mail and any attachments is confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient. Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. Companies Act information: Registered name: Experian Limited Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Place of registration: England and Wales Registered number: 653331 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: TSO/ISPF Screen Swap
I have a command 'SS' set to invoke SELECT CMD(%STARTUP ZPARM); which lists the current ISPF applications executing and allows you to select from the list. I think I obtained the 'STARTUP' command from a CBT tape, but don't know off the top of my head. It's useful when you have lots of different applications running under ISPF. Mike. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Bonno, Tuco Sent: 14 July 2008 14:05 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: TSO/ISPF Screen Swap what I think you're looking for is a (separate) pfkey set up for SWAP NEXT the next is what makes it rotate thru all the sessions, one by one. /s/ tuco bonno graduate, College of Conflict Management; University of Southeast Asia; I partied on the Ho Chi Minh Trail - tiến lên !! -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Howard Rifkind Sent: Monday, 14 July, 2008 08:12 AM To: IBM-MAIN@BAMA.UA.EDU Subject: TSO/ISPF Screen Swap I used to have the PF keys on my PC set put to swap between different screens but I'm no longer in possession of that PC and I can't recall how I did this. I'm opening up several screens with the start command and I would like to know how to switch between them. If I open up three screens and use the swap command I seem to only be able to switch between two of them. Also, how do I go about seeing which screen are available, I used to see this also with a PF key setting and then select the one I wanted. Thanks... This e-mail has come from Experian, the only business to have been twice named the UK's 'Business of the Year’ === Information in this e-mail and any attachments is confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient. Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. Companies Act information: Registered name: Experian Limited Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Place of registration: England and Wales Registered number: 653331 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: storing pdf documents an DB2
This should be achievable in COBOL. I've done CLOBs. Handled exactly like any other column type, the only difference being around how to declare the host variables in the cobol source: EXEC SQL BEGIN DECLARE SECTION END-EXEC. 01 WS-CLOB USAGE IS SQL TYPE IS CLOB (1M). EXEC SQL END DECLARE SECTION END-EXEC. - I'd guess a BLOB would use the same structure(?) I recall DV2 v7.1 had extra restrictions around tables including large objects, but 8.1 makes most of the differences/difficulties go away. HTH, Mike. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Jim McAlpine Sent: 11 April 2008 16:01 To: IBM-MAIN@BAMA.UA.EDU Subject: storing pdf documents an DB2 We have a need to store pdf documents in DB2 tables. I know that DB2 supports blob columns which we can presumably use to store the pdfs. The question I have is can we use COBOL to manipulate/insert the data into the DB2 blob columns. I had a quick look at the COBOL FMs but there seems to be little mention of blobs. Has anyone successfuly done this. Jim McAlpine -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html This e-mail has come from Experian, the only business to have been twice named the UK's 'Business of the Year’ Register for our free online seminar on 24th April where we advise marketers on how to achieve marketing relevance with their customer communications. Visit www.experianim.com/marketingrelevancewebinar (simply paste the URL into your browser) === Information in this e-mail and any attachments is confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient. Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. Companies Act information: Registered name: Experian Limited Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Place of registration: England and Wales Registered number: 653331 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: z/OS messages libraries - continued
For LE messages, can't you use CEEMGET to convert a condition token to text (although not all messages are trapped in this way...)? -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Francois Guillez Sent: 04 March 2008 15:29 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: z/OS messages libraries - continued thanks Lizette. Actually I use CEE callable service to handle abends and it gives me a code 32xx so I'd like to get the corresponding message. example : 3209 Fixed-point divide exception -- this message ?? refer to page 228 in z/OS V1R9.0 Language Environment Programming Reference On Tue, 4 Mar 2008 10:02:01 -0500, Lizette Koehler [EMAIL PROTECTED] wrote: Francois, That is an ISPF Message Skeleton Library. Therefore you would have amp;vars that would not be resolved. I am not sure that is exactly what you need. The library is setup with message prefixes but not all messages are in this library. Lizette Actually I found SYS1.MSGENU library which seems to contain all OS messages, only I don't know how to get the message code from a program. Anybody help me? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html This e-mail has come from Experian, the only business to have been twice named the UK's 'Business of the Year’ Have you read our new resource on Affinity Marketing 'Everybody is Somebody's Customer' where we share our experience of managing successful affinity campaigns? Download from www.experianim.com/affinitymarketing (simply paste the URL into your web browser) === Information in this e-mail and any attachments is confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient. Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. Companies Act information: Registered name: Experian Limited Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Place of registration: England and Wales Registered number: 653331 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Cross-assembler : HLASM -- 8086
Thanks for all ideas and options. Clem contacted me directly and he's now retrieved his 370to486 utility, so I'll probably give that a whirl. As to why ... Well, as John noted it would be better to figure out the functionality and re-write in a 'native' language but this is a 25 year old suite with 25 years of (mainly un-documented) maintenance, so figuring out what it does isn't easy. But something I'll do given time. The immediate need (not mine) is to have the code executing on wintel to enable off-mainframe services to execute it without having to call the mainframe, just for this isolated function (which as I mentioned is just number crunching). Cheers, Mike. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Behalf Of Andy Wood Sent: 01 June 2007 11:10 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Cross-assembler : HLASM -- 8086 On Thu, 31 May 2007 08:47:53 -0700, Richard Pinion [EMAIL PROTECTED] wrote: Appears that Mr. Clark's software is no longer available. I tried to download 370to486 and got file not found on server. I tried the link and it worked for me - I was able to download 370to846.zip. This e-mail has come from Experian, the only business to have been twice named the UK's 'Business of the Year’ === Information in this e-mail and any attachments is confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient. Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. Companies Act information: Registered name: Experian Limited Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Place of registration: England and Wales Registered number: 653331 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Cross-assembler : HLASM -- 8086
Hi, Does anyone know of a product that will take HLASM source and produce object or executables for the wintel platform? I'm aware of tachyon and dignus (even pc370!) which can take HLASM, assemble/link, and emulate the execution on wintel, but I want native '8086' (or whatever it's called) output (I guess that source or object output would be okay). The code is 'pure' HLASM (number-crunching, not accessing any MVS services), so it shouldn't need to handle many environment issues (other than passing parameters in, and getting the response out). Thanks in advance, Mike Flint, Systems Consultant, Experian. This e-mail has come from Experian, the only business to have been twice named the UK's 'Business of the Year’ === Information in this e-mail and any attachments is confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient. Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. Companies Act information: Registered name: Experian Limited Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Place of registration: England and Wales Registered number: 653331 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: Hexadecimal value
Seen many times before: 05 ws-num5 PIC 9(5) COMP-3. 05 ws-hexvalue2 redefines ws-num5 PIC X(2). 05 ws-hex5 PIC 9(5). 05 ws-display4 redefines ws-hex5 PIC X(4). (place hex code in hexvalue2) move ws-num5to ws-hex5. inspect ws-display4 converting x'FAFBFCFDFEFF' to 'ABCDEF'. (output in ws-display4) -this is for two bytes obviously, so increase the value(!) -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Behalf Of Amlan Prasad Sent: 16 May 2007 16:55 To: IBM-MAIN@BAMA.UA.EDU Subject: Hexadecimal value Hi, I have a requirement to send the Hex value in the file field. For example after some caluculation I get a 4-char value whose hex equivalent is X'076DC419'. Now I need to pass '076DC419' in a 8-char field to be written in a file. This will be processed by the other system. How can I do it in COBOL in Mainframe? Thanks, Amlan -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html This e-mail has come from Experian, the only business to have been twice named the UK's 'Business of the Year’ === Information in this e-mail and any attachments is confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient. Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. Companies Act information: Registered name: Experian Limited Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Place of registration: England and Wales Registered number: 653331 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: What's your favorite ASCII and EBCDIC code pages?
I use translations: EBCDIC CP 1146 to/from ASCII CP 850 - dealing with translations purely on mainframe. On inbound from off-mainframe servers, we use ISO-8859-01 and 5348, and convert to 1146. Also use UTF-16BE (CP 1200) on outbound to off-mainframe servers, so this has been converted from 1146. Mike Flint, Systems Consultant, Experian. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Behalf Of David Cole Sent: 13 June 2006 18:39 To: IBM-MAIN@BAMA.UA.EDU Subject: What's your favorite ASCII and EBCDIC code pages? Hi, Trying to come up with a decent (whatever that means) EBCDIC to ASCII translation is a bit like trying to decide the length of the coastline of Maine. It's all a matter of opinion. So... I am asking your opinions ... My initial choice was to produce a table to translate the mutually defined characters of the 037 code page (one of the EBCDIC code pages) into the corresponding characters of the 437 code page (MS-DOS ASCII). But both those code pages include a lot alphabetics with various diacritical marks, and being an American, I don't need or care much about those. (Now DON'T flame me for that. They just don't figure into my needs.) I DO care about several special symbols such as vertical bar, broken vertical bar, copyright symbol, trademark, registered trademark, not sign, upside down question mark and exclamation point, square brackets, etc. ... a genuinely motley crew of stuff. Complete reversibility doesn't matter. I need to reverse translate only those characters mutually defined to both code pages. Everything else can just go to ... well ... nulls, periods, blanks, whatever. So, what are your favorite code pages? Or is that too restrictive a question. Should I be asking, what are your favorite translations? Thanks, Dave Cole REPLY TO: [EMAIL PROTECTED] Cole Software WEB PAGE: http://www.colesoft.com 736 Fox Hollow RoadVOICE:540-456-8536 Afton, VA 22920FAX: 540-456-6658 -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html This e-mail has come from Experian, winner of the UK's 'Business of the Year' 2003 and 2005. == Information in this e-mail and any attachments are confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient Experian Limited (registration number 653331) Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: CICS TS v3.1 and ICSF
Hi, I've done this under z/OS 1.4 and CICS TS 1.3, and worked fine. I'm assuming(!) they'll be no problems under 3.1. This was using the straight encode/decode services. There appeared to be no hit on the CICS region (these weren't long-running calls) - a trace showed nothing of interest. I didn't have the CICS-ICSF Attachment Facility installed. Given that the attachment facility seems to exist to isolate the CICS QR TCB from Waits, using the 3.1 OPENAPI facility might be just as good an alternative option, if you're concerned about impact on other work. Check out Appendix B of the ICSF System Programmer's Guide (SA22-7520) for details on the attachment facility. (try posting to the CICS-L mailing list - they might have more info) HTH, Mike Flint, Systems Consultant, Experian. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] Behalf Of Roger Davis Sent: 19 May 2006 11:40 To: IBM-MAIN@BAMA.UA.EDU Subject: CICS TS v3.1 and ICSF Hi, We're running z/OS 1.6 and CICS TS 3.1 and in the midst of PCI/DSS evaluation work. A question of whether a CICS COBOL transaction is able to use ICSF has arisen. Can anyone please help in this, as copious interrogation of CICS manuals has not helped much. We need to see if we can encrypt and decrypt data from files read by applications. Kind regards, Roger Davis Snr Systems Software Engineer The Logic Group UK -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html This e-mail has come from Experian, winner of the UK's 'Business of the Year' 2003 and 2005. == Information in this e-mail and any attachments are confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient Experian Limited (registration number 653331) Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Code style validation tool
Hello, I've been asked to see if there's an application code validation tool on the market. Something like ASG's JCLPREP but for application code (primarily COBOL) ... a tool that would look at code and validate it's style and usage against a set of rules (e.g. amount of comments, best use of numeric fields, data-type conversions). I'm led to believe that a number of such tools exist for off-mainframe development languages, and are used to ensure a minimum standard. Does anyone know of, or use, such a tool? (I admit, personally, that I'm a tad sceptical about how an automated tool can help improve coding standards; I'm just following up on a request). Thanks, Mike Flint, Systems Consultant, Experian. == Information in this e-mail and any attachments are confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient Experian Limited (registration number 653331) Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
Re: SUPERC Insights
Bill, Here's my take on what you are after. I have two files: Old one *** 10 FRED 20 JON 30 SHEILA 40 JUNE 50 ALICE New one *** (changes) 10 FRED 20 JIM changes in cols 4-9 (a relevant change) 30 SHEILA changes in cols 12-20 (an irrelevant change) 35 SHEILA a new record 40 JUNE record '50 ALICE' deleted. To follow your requirements, I want a report on any added or deleted records, or any changed records in columns 4 to 9. I don't want any report of lines changed in columns 12 to 20. So, in this example, I want report of lines 20, 35, and 50. I use 'Compare Type' = Line, and 'Listing Type' = Delta My process statements are: CMPCOLM 1:2 4:8 And this produces: I - 20 JIM D - 20 JON I - 35 SHEILA D - 50 ALICE ... is this what you are after? You need to include (what you see as) your key columns in the comparison as well. SuperC doesn't know that changes in this column are relevant unless you tell it to. Specifying only cols 999:1005 means it will ignore changes in any other columns - including your 'record key'. Adding this should fix your problem, hopefully. hth, Mike Flint, Systems Consultant, Experian. -Original Message- From: George, William (DHS-ITSD) [mailto:[EMAIL PROTECTED] Sent: 21 September 2005 21:04 To: IBM-MAIN@BAMA.UA.EDU Subject: Re: SUPERC Insights Barry Thanks for the reply. You said, Columns 999:1005 is length of seven, not the six you specify. Very true and this is what happens when I type without thinking. Lets see if I can restate it better. What I'm attempting to do is compare two files and; 1) report any differences found within a certain column range and 2) any added or deleted records. I have two test files I'm working with that have 20 records each. The files are exact until I made these changes to the one I'll call NEW (Key is the first 9 digits of the record) 1) record key 9 deleted from NEW 2) record key 5 had data changed in cols 999-1004 3) record key 2 also had data changed 4) record key 99989 was ADDED to the NEW file RESULTS When I execute SUPERC with no process statements the output from SUPERC seems as I would expect (run with Compare Type = FILE Listing type = Delta and NO process options) D - 9 3J90004514W5M38 3 ROGERS snipped! Find out about The Experian Conference 2005 at www.experian.co.uk/conference2005 == Information in this e-mail and any attachments are confidential, and may not be copied or used by anyone other than the addressee, nor disclosed to any third party without our permission. There is no intention to create any legally binding contract or other binding commitment through the use of this electronic communication unless it is issued in accordance with the Experian Limited standard terms and conditions of purchase or other express written agreement between Experian Limited and the recipient Experian Limited (registration number 653331) Registered office: Talbot House, Talbot Street, Nottingham NG80 1TH Although Experian has taken reasonable steps to ensure that this communication and any attachments are free from computer virus, you are advised to take your own steps to ensure that they are actually virus free. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [EMAIL PROTECTED] with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html