insert into mail (SEQ ID, MAIL, EMAILID, TEMPLATEID)
values (1234, (mail.nextval), '<email id from input file>', 5376);
In my output everything is unchnanged except email id. Here i need to insert the email id into the output string. I have to do this in jcl. But i am getting spaces after email id as i am taking email address from input file as fixed lenght.
Is there any solution to fit the exact email address into the output?
insert into mail (SEQ ID, MAIL, EMAILID, TEMPLATEID)
values (1234, (mail.nextval), '<email id from input file>', 5376);
In my output everything is unchnanged except email id. Here i need to insert the email id into the output string. I have to do this in jcl. But i am getting spaces after email id as i am taking email address from input file as fixed lenght.
Is there any solution to fit the exact email address into the output?
Please help me on this.
2. There is absolutely no way to do it in JCL. Period.
3. The "insertion" of a record can be done in VSAM using existing VSAM files (but not using sequential files as you are dealing with). This is absolutely different issue from what you need to achieve. Period.
4. Please, choose any other of 100500 available tools you are familiar with? If there is any tool familiar to you, the job can be done in minutes.
If no such tool is available. I suggest you to start RTFM.
Hint: start reading about SORT tools (DFSORT, or SYNCSORT)
You can also use REXX, or COBOL, or C/C++, or Java-Python-etc. or many-many other tools you are able to use.
5. Your topic is titled "Inserting variable length into output file"
FYI: "variable length" is a numeric value.
It is not clear, how do you need to "insert" any numeric value "into output file"?
The content of your topic doesn't match its title.