I'm looking for what I think is a System Profile Option within Oracle Financials that will allow me to open Concurrent Program Define at the same time as Concurrent Program Executables so that I can copy and paste from one to the other. I can do this in our Dev. Environment but we recently...
That was it! The command line from feherke helped me get it working. I needed to put the s's that they highlighted in their code example along with that - in front of the last e.
Thanks everyone!
I'm sorry I uploaded the wrong error message. With the information above it's not the -e error it's the following one.
sed: -e expression #5, char 2: Unknown command: `<'
The -e occurs if I comment out the -e's in the middle of the script.
This is my code and I'm getting the unknown command...
Thanks for the tip. Now I'm getting a new error! Here's my revised code.
sed -e 's/<SITEID>/Server\\\\FolderA\\\\FolderB\\\\/g' \
-e "s~<USERID>~$ftp_user~g" \
-e "s~<PASSWD>~$ftp_user_pass~g" \
-e "s~<INFILE>~$input_filename~g" \
-e "~<FILEDIR>~Lease~g" \
e "/<OUTFILE>/$new_file/g" <...
I am a newbie to Unix and sed so although I saw some posts that were similar to what I'm having problems with I couldn't get the suggestions to work with my problem.
I am modifying a previously built .prog that has a sed command in it that builds an ftp command when the .prog is ran. My...
I am using PLSQL to call the Payables Open Interface Program. Everything runs rather smoothly except for the fact that the Payables Import will only import 15 records at a time. After that it gives me the errors
The account created with overlay is invalid
and
Invalid distribution account
The...
Thanks for your responses I found a fix to my solution. I added "TERMINATED BY WHITESPACE" after the last column. I've posted my final control file below.
OPTIONS (SKIP = 1)
LOAD DATA
INFILE '/VendorRepository/vendor/test.csv'
REPLACE
INTO TABLE xxhh_ap_suppliers_stg
FIELDS TERMINATED BY ','...
Thanks for the responses.
It looks like there is some dummy data added on to each of my SSN's. So it's nothing to do with what i thought (The Optionally enclosed). I'm guessing these are carriage return values. When I increase the destination field length to 10 it runs fine. I've been...
Hi, I am very new to Oracle and SQL Loader, this is actually my first sqlldr program that I have written. What I am wondering is why this does not work when it appears to work for everyone that I have found on the web.
My Control File is below
OPTIONS (SKIP = 1)
LOAD DATA
INFILE...
Hi, we recently converted to Access 2007 and I am having trouble with one of my forms. I currently have a form where you enter search criteria in and hit "Search" the form builds a query and then uses an unbound form to display the query results. However, when I login as a user this form is...
I forgot to paste my Replication Code. I am using Access 2007 with a Access 2003 MDB.
Set db = DBEngine(0).OpenDatabase("C:\Snapshot\LocalReplica.mdb")
strSyncTargetDB = "\\server\ServerReplica.mdb"
db.Synchronize strSyncTargetDB, dbRepImpExpChanges
db.Close
My references are still...
sorry for the long wait between responses but here it goes.
1) This is a split database. There is a front end and a back end. The users have laptops that have a front end on their laptop along with a backend. As they work the data gets populated in their backend. When they get to a hotspot...
We are currently converting from Access 2003 to Access 2007. I have
an Access app that is going to be very difficult to convert. This App
is used by people that are out in the field and are a long distance
from where our Access Databases are. So that is why we have
Replication set up. So...
Thanks for the reply, but the interesting part is the MDE that I created in Access 2000 is the only part that doesn't work. If I load the Access 2000 mdb with 2003 it works fine. If I convert the app to 2003 and create an mde both work fine. The references looked ok to me too. The ones that...
I created an MDE with Access 2000 but when I try to use this mde on a PC with access 2003 I get the following error: requested type library or wizard is not a vba project
I have other MDE's that I have made with Access 2000 that work fine with 2003. And the MDE that errors will work if I...
One of our users is getting the following error when she tries to send out Auto Emails. This error comes up at the part of code "domSession.Initialize ("")", we use Lotus Notes 6.5.4. The Auto Email works on other pc's including mine. Her actual error is as follows:
Microsoft Visual C++...
I got Access to write to Excel. I had to set up the path to my workgroup file:
SystemDBPath = "\\path\master.mdw"
AccessEngine.SystemDB = SystemDBPath
Now my question is this: How can I grab the login name used to login to the LAN of the PC? I know this can be done in access VBA but...
Thanks for the tip. The error is:
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
Did I mention that we have security on our access databases where you have to login with a username and password to get to the data? If not how...
...to do what I need but I could never get it to write to my access db. Any help would be greatly appreciated!
Below is the code i've used:
'' ***************************************************************************
'' Purpose : Access Log File : Record process activity
'' Written ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.