MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 15 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Can we Read XML file as input from a Stored Procedure
aruna_space

Replies: 6
Views: 4844

PostForum: Application Programming   Posted: Thu Jul 10, 2014 4:21 am   Subject: Can we Read XML file as input from a Stored Procedure
Hi Kolusu,

I still Need to recieve XML input into the Stored Procedure through Call string.

Need to read the XML data from Call String and INSERT it into the table that is created.

Thanks,
A ...
  Topic: Can we Read XML file as input from a Stored Procedure
aruna_space

Replies: 6
Views: 4844

PostForum: Application Programming   Posted: Wed Jul 09, 2014 8:49 am   Subject: Can we Read XML file as input from a Stored Procedure
Hi,

I found a way to CREATE a table with XML data with the help of the link given.
But still, the data i am gettin in XML format is around 90,700 bytes. I need to recieve it as input through Store ...
  Topic: Can we Read XML file as input from a Stored Procedure
aruna_space

Replies: 6
Views: 4844

PostForum: Application Programming   Posted: Wed Jul 02, 2014 5:30 am   Subject: Can we Read XML file as input from a Stored Procedure
Hi,

We have a very BIG data which needs to be processed in Stored Procedure, which is not sufficient to pass in Linkage section as PARM value. So it comes in as XML file.
Can we process the XML f ...
  Topic: Generate a report with PGM name and its stage
aruna_space

Replies: 2
Views: 1621

PostForum: Application Programming   Posted: Wed Jun 30, 2010 4:49 am   Subject: Generate a report with PGM name and its stage
Hi,

Could someone help me in generating a report with a list of known programs, along with the stage it is present (UNIT/SYST/ACPT) the copybooks used in the program along with the stage
DCLGEN's ...
  Topic: Split a file
aruna_space

Replies: 2
Views: 1642

PostForum: Utilities   Posted: Thu May 31, 2007 5:44 am   Subject: Split a file
the input file : IN

H 10
1
2
3
4
5
6
7
8
9
10
T 10
H 5
11
12
13
14
15
T 5
H 3
16
17
18
T 3

i need to split it into

OUT1:
H 10
1
2
3
4
5
6
7
8
9
10
T 10

O ...
  Topic: Compare and Split two files using ICETOOL
aruna_space

Replies: 5
Views: 4347

PostForum: Utilities   Posted: Tue May 15, 2007 7:07 am   Subject: Compare and Split two files using ICETOOL
In the T1 file we dont get the condition 'VB' at all, we either get 'BB' or 'VV' then why do we have this check on 'VB'

OUTFIL FNAMES=OUT3,INCLUDE=(41,2,CH,EQ,C'VB',AND,
(10,3,CH,NE,30,3,C ...
  Topic: Compare and Split two files using ICETOOL
aruna_space

Replies: 5
Views: 4347

PostForum: Utilities   Posted: Sun May 13, 2007 10:32 pm   Subject: Compare and Split two files using ICETOOL
Hi Frank,

//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*
//IN1 DD DSN=... input file1 (FB/11)
//IN2 DD DSN=... input file2 (FB/11)
//TEMP DD DSN ...
  Topic: Compare and Split two files using ICETOOL
aruna_space

Replies: 5
Views: 4347

PostForum: Utilities   Posted: Wed May 09, 2007 5:53 am   Subject: Compare and Split two files using ICETOOL
Hi,

Can we do a record vise comparison in two files using ICETOOL,

In this case, there are two files, Field1 is comon in both the files,

1. If there is a match of the Field1, Field2 and Fiel ...
  Topic: MERGE files Using the SPLICE in ICETOOL
aruna_space

Replies: 8
Views: 3594

PostForum: Utilities   Posted: Thu Mar 29, 2007 10:21 pm   Subject: MERGE files Using the SPLICE in ICETOOL
Thanks a ton Frank Smile

It works fine
  Topic: MERGE files Using the SPLICE in ICETOOL
aruna_space

Replies: 8
Views: 3594

PostForum: Utilities   Posted: Tue Mar 27, 2007 12:06 am   Subject: MERGE files Using the SPLICE in ICETOOL
Hi Frank

File 1:

FieldA FieldB FieldC
1-6 7-26 27-33
100 200 1234
101 201 1234
102 202 1111

FieldA - 1-6 PIC(x)
FieldB - 7-26 PIC(x)
FieldC - 27-33 S9(12) Co ...
  Topic: MERGE files Using the SPLICE in ICETOOL
aruna_space

Replies: 8
Views: 3594

PostForum: Utilities   Posted: Mon Mar 26, 2007 12:05 am   Subject: MERGE files Using the SPLICE in ICETOOL
Sorry for the confusion the output file has:

FieldB FieldC Field2 Field3
200 1234 1100 1200
201 1234
202 1111 2100 2200
  Topic: MERGE files Using the SPLICE in ICETOOL
aruna_space

Replies: 8
Views: 3594

PostForum: Utilities   Posted: Sun Mar 25, 2007 10:30 pm   Subject: MERGE files Using the SPLICE in ICETOOL
thats Because it doesnt have a match in the second file, so those fields are defaulted
  Topic: MERGE files Using the SPLICE in ICETOOL
aruna_space

Replies: 8
Views: 3594

PostForum: Utilities   Posted: Sat Mar 24, 2007 3:12 am   Subject: field incompatibilities in the input n output files
there are incompatibilities in the input and output files

In the input files:
Field C - S9(12) Comp-3
Field 2 & Field 3 - S9(9) comp

The Output file:
Field C - 9(12)
Field 2- 9(09)
Fiel ...
  Topic: MERGE files Using the SPLICE in ICETOOL
aruna_space

Replies: 8
Views: 3594

PostForum: Utilities   Posted: Fri Mar 23, 2007 10:18 pm   Subject: MERGE files Using the SPLICE in ICETOOL
File 1: This file is of length 15



FieldA FieldB FieldC
100 200 1234
101 201 1234
102 202 1111


File 2: This file is of length 25


FieldA FieldB Field2 Field3 ...
  Topic: Using SPLICE to merge records.
aruna_space

Replies: 5
Views: 2790

PostForum: Utilities   Posted: Fri Mar 23, 2007 6:15 am   Subject: Need to splice a file of variable format
File 1:

FieldA FieldB FieldC
100 200 1234
101 201 1234
102 202 1111


File 2:

FieldA FieldB Field2 Field3 FieldC
100 200 1100 1200 1234
102 202 2100 22 ...
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group