Author |
Message |
Topic: Can we Read XML file as input from a Stored Procedure |
aruna_space
Replies: 6
Views: 4844
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: Utilities Posted: Thu Mar 29, 2007 10:21 pm Subject: MERGE files Using the SPLICE in ICETOOL |
Thanks a ton Frank
It works fine |
Topic: MERGE files Using the SPLICE in ICETOOL |
aruna_space
Replies: 8
Views: 3594
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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
|
Forum: 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 ... |
|