As a guess, it looks like when you modified this line in my script:
to insert your input file name, you omitted the space between the single quote and the filename as in:
That space must not be removed. Try:
And, there has to be a space between /usr/xpg4/bin/awk and the opening single quote. I.e.,:
not:
Last edited by Don Cragun; 02-21-2014 at 12:14 AM..
Reason: Note both missing spaces; not just the last. Fix typo.
when I compile program 1: I am getting below error
But in program 2: I am not sure how to pass .txt data values to Insert table(marked as red text)
Please help me on this.
I have absolutely no idea how message #16 is related to anything else in this thread.
Did the changes I suggested in message #15 in this thread work for you?
Have all of the issues you raised in the 1st message in this thread been resolved?
If you have a different problem where you also need help, open a new thread with a clear description of what you are trying to do, what code you're using, what you input looks like, what output you are trying to produce from that input, and a clear description of what processing should be performed to transform your input into the desired output.
The trace log from running (not compiling) loaddata.ksh clearly shows that other than the comment on the first line of the script and the start of the subshell on line 6, no other line in your shell script contains a valid shell command. Your second script suffers from similar problems.
My first thread finger command issue was resolved. I have sent other message with subject "loading text file into table" with followng details
I have text file like below
Code:
Code:userreport.txt sinlgae34f,n,Mon,Aug,19,,2013,onggi11ggi11,n,Thu,Jul,12,,2012,onhca05hca05,n,Mon,Apr,4,,2011,on,r45f vr45fv,n,Fri,Feb,7,2014,16:5e43vg,4er34,n,Tue,Aug,21,,2012,onrt4566rt4566,n,Tue,Nov,12,2013,12:
I would like to load this userreport.txt file into table.
I used two program
Code:
program1: #!/bin/kshload datainfile 'userreport.txt'INSERT INTO lastlogonFIELDS TERMINATED BY ','(useridDayMonthDateyear )
Code:
Program 2: #!/bin/kshfilename=userreport.txtwhile IFS=, read doINSERT INTO lastlogondone
when I compile program 1: I am getting below error
Code:
loaddata.ksh[2]: load: not found+ infile userreport.txtloaddata.ksh[3]: infile: not found+ INSERT INTO lastlogonloaddata.ksh[4]: INSERT: not found+ FIELDS TERMINATED BY ,loaddata.ksh[5]: FIELDS: not found+ useridloaddata.ksh[7]: userid: not found+ Dayloaddata.ksh[8]: Day: not found+ Monthloaddata.ksh[9]: Month: not found+ Dateloaddata.ksh[10]: Date: not found+ yearloaddata.ksh[11]: year: not found
In program 2: not inserting into text file
Code:
+ filename=userreport.txt+ read+ IFS=,+ INTO lastlogonloaddata1.ksh[5]: INTO: not found
See following are the basic syntax of reading files, actually Don reported and told you to correct in message #4, see what you have missed just read is not enough.
OR in bash
Hi
Does anyone know if there is anyway of doing the finger command for all user id's in my enviroment. What I need to obtain is the full names of all users on the system.
I know if i do the finger command with no arguments it will list users currently logged in, but i need all users...
... (2 Replies)
Two things : On the first place i am really desperate, on the second i am about to throw my laptop away to the recycle bin in a while.
Ok now that i expressed my feeling let me describe you this mad situation.
Code:
print $1;
("finger -m " $1 "| head -1") | getline userinfo
print... (6 Replies)
I want to know the correct version of how i should use the finger command in this example below.(os is debian lenny)
(nymserver.pl is located in /home/nymserv directory.)
the two versions are :
(in/etc/inetd.conf)
finger stream tcp nowait nymuser /usr/nym/nymserv nymserv... (3 Replies)
Is there any possible way to get rid of the header when I do finger ?
I want to get rid of
Login Name Tty Idle Login Time Office Office Phone
as the header.
Please let me know how to do it. (2 Replies)
Hi,
iam using sunsolaris.
when you type finger command -- it dispalys information about local and remote users.
but here it shows as can't stat /dev/gold:8664
can anybody help what is the solution for this error.
previously the output came.
thanks,
shan (1 Reply)
Hello all,
Here is what I am trying to do. If a user exist, then send an echo "EXIST" or else "DOES NOT EXIST". (under HP-UX)
Kind of:
#!/usr/bin/sh
USER=mylogin
finger $USER
if $? = 0
then
echo "EXIST""
else
echo "DOES NOT EXIST"
fi (10 Replies)
Hey, I was wondering If anybody knew of a way to make a log of all users who type the command finger username when username is my own.
I would like to see who is keeping track of me :)
Thanks (3 Replies)
is there a way to show information on all the users on your system? when i use 'finger' is only shows users names and info who are currently on the system. is there a way to show all accounts? thanx! (5 Replies)
Hi, I've been using unix at college for a few weeks now and I have come up against a few stumbling blocks:
- Most unix commands seem to work w/ regexps - the computers I and my group are allowed to logon to are all itsunXX where XX is a number. if I can {finger @itsun88} to find out that I and... (1 Reply)