RE: [EXTERNAL] Re: CPYF: blanks -> Null

Hi Justin
Not too sure what you mean by both files are dynamic
I am assuming that when you say the from file is a flat file, Im assuming that you mean its just a string of data
You can still use SQL against a flat file (string of data)



Alan Shore
Solutions Architect
IT Supply Chain Execution

[cid:image001.png@01D706C4.B05C61C0]

60 Orville Drive
Bohemia, NY 11716
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
E-mail : ASHORE@xxxxxxxxxxxxxxxxxxxx

'If you're going through hell, keep going.'
Winston Churchill

From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Justin Taylor
Sent: Friday, February 19, 2021 1:29 PM
To: MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: [EXTERNAL] Re: CPYF: blanks -> Null

Not easily. The from & to files are dynamic, and the from file is a flat
file.


date: Fri, 19 Feb 2021 15:46:47 +0000

from: Alan Shore via MIDRANGE-L <midrange-l@xxxxxxxxxxxxxxxxxx<mailto:midrange-l@xxxxxxxxxxxxxxxxxx>>
subject: RE: [EXTERNAL] CPYF: blanks -> Null

Hi Justin
Can you not use SQL?
Not knowing how many fields we are talking about on the file - lets say 5,
and the 4th one is the date
Insert into COPYTOFILE
(Select Field1, Field2, Field3, current_date, Field5 from COPYFROM)

Alan Shore
Solutions Architect
IT Supply Chain Execution

[cid:image003.png@01D706AC.84698B50]

60 Orville Drive
Bohemia, NY 11716
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
E-mail : ASHORE@xxxxxxxxxxxxxxxxxxxx<mailto:ASHORE@xxxxxxxxxxxxxxxxxxxx>

'If you're going through hell, keep going.'
Winston Churchill

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L@xxxxxxxxxxxxxxxxxx>
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l<https://lists.midrange.com/mailman/listinfo/midrange-l>
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx<mailto:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx>
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l<https://archive.midrange.com/midrange-l>.

Please contact support@xxxxxxxxxxxxxxxxxxxx<mailto:support@xxxxxxxxxxxxxxxxxxxx> for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com<https://amazon.midrange.com>



The Nature’s Bounty Co. is now The Bountiful Company! Our email address will be changing from @nbty.com to @bountifulcompany.com. Please update your email address book so that important communications are not interrupted.