OraFAQ Forum: Unix » How to pass an input file which has date included in it and it keeps changing when sqlloading

Home » Infrastructure » Unix » How to pass an input file which has date included in it and it keeps changing when sqlloading (sqlldr and unix script)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to pass an input file which has date included in it and it keeps changing when sqlloading [message #553669]

Mon, 07 May 2012 13:52

dora
Messages: 13
Registered: January 2012

Junior Member

Hi

I am running the control file in unix,


sqlldr abcdata@DUMMY/daddy control=loadThirdPartyTest.ctl data=$OUTDIR/'THIRD_PARTY.20120507.txt'

The input file, THIRD_PARTY.20120507.txt will change its name every day with a new date.
I have tried the input file name, as THIRD_PARTY.*.txt, and it doesnot recognise *.

Anyhelp is appreciated.Thank You.

Report message to a moderator

Re: How to pass an input file which has date included in it and it keeps changing when sqlloading [message #553670 is a reply to message #553669]

Mon, 07 May 2012 14:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

export TODAY=20120107
sqlldr abcdata@DUMMY/daddy control=loadThirdPartyTest.ctl data=$OUTDIR/${TODAY}.txt

just establish environmental variable correctly prior to invoking sqlldr

Report message to a moderator

Re: How to pass an input file which has date included in it and it keeps changing when sqlloading [message #553672 is a reply to message #553669]

Mon, 07 May 2012 14:13

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

it doesnot recognise *.

Remove the '.
Or better put the date in a variable.
CURDATE=`date +'%Y%m%d'`.

Regards
Michel

Report message to a moderator

Re: How to pass an input file which has date included in it and it keeps changing when sqlloading [message #553673 is a reply to message #553672]

Mon, 07 May 2012 14:28

dora
Messages: 13
Registered: January 2012

Junior Member

Hi Sir,

The Input file for example, as said earlier is THIRD_PARTY.20120507.txt
comes in today, as the date added to the input file name is today,

But i didnot run the unix script containing the sqlldr today, instead
I will run it tommorrow.
The file contains yesterday's date on it.

In that situation, how do i consider the input file to load data using the sqlldr from unix.

Note: The input files come on certain occassions, I might not run the sqlldr the day we get input files.
Note: Every input file name contains first part of the name same, but the date difference based on when it comes.

Thank You.

Report message to a moderator