Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Number of rows loaded via sqlldr
Top Forums Shell Programming and Scripting Number of rows loaded via sqlldr Post 302902185 by Pratiksha Mehra on Monday 19th of May 2014 08:08:07 AM
Old 05-19-2014
Hi,

I have text file as EG.txt

the file content is like:

CACZ885M2301|1569009|MONTH0|ERT|7001455|SUPINE|12
CACZ885M2301|1569009|MONTH0|ERT|7001455|SUPINE|12
CACZ885M2301|1569009|MONTH0|ERT|7001455|SUPINE|12

when i do /cat AE.txt | wc -l
it displays 2 instead of 3..

Any idea why its showing (number of rows - 1)
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

help getting records loaded from sqlldr log

Does anyone have the code to look in a slqldr log file and get the total amount of records loaded? If so, could you please post. Thanks much. (0 Replies)
Discussion started by: ecupirate1998
0 Replies

2. Shell Programming and Scripting

return number of rows selected

Hi all, i am doing a perl script to read from a db. I am able to retrieve the rows, but i am unable to return the number of rows selected. i tried $selectedrows = $sth->numrows; i got the error msg: Can't locate object method "numrows" via package "DBI::st" i changed it to $selectedrows =... (7 Replies)
Discussion started by: new2ss
7 Replies

3. Shell Programming and Scripting

Ability to store number of rows

Hi, I am creating a korn shell script and i'm trying to find out what the total number of rows are in a specific text file and i need to store that number in a variable withing the script. i know wc -l gives you the number, but it also has some leading spaces and then writes out the file name... (2 Replies)
Discussion started by: scabral
2 Replies

4. UNIX for Dummies Questions & Answers

Number Grouped Rows in File

I have a file containing 750,000 records and have managed to sort them by related columns and now i'd like to add an ID number to the front of each line of the records that are grouped together. Which probably makes no sense so i have provided some example data and desired result. Given data.txt... (2 Replies)
Discussion started by: RacerX
2 Replies

5. Shell Programming and Scripting

How to get total records loaded from sqlldr log file

Hi, I am loading data in the database table through sqlldr. I have to find total records loaded from sqlldr log file and store it in a variable in my script. How do I get it? Thank you. (3 Replies)
Discussion started by: mrpranab
3 Replies

6. Shell Programming and Scripting

how to add the number of row and count number of rows

Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count The input file: 21 2341 A 21 2341 A 21 2341 A 21 2341 C 21 2341 C 21 2341 C 21 2341 C 21 4567 A 21 4567 A 21 4567 C ... (6 Replies)
Discussion started by: juelillo
6 Replies

7. Shell Programming and Scripting

awk number rows from 1 to 3 in file

I have a file with the following format, i need to change de field9 each 3 rows to renumber field9 with gpo1, gpo2, gpo3. I need to use awk Original file field1 field2 field3 field4 field5 field6 field7 field8 gpo3 field1 field2 field3 field4 field5 ... (3 Replies)
Discussion started by: robonet
3 Replies

8. Shell Programming and Scripting

Delete rows with particular number of columns

Hello Guys I have a flat file with few thousands of rows. Now each rows have different number of columns I want to delete the rows which has not equal to 749 columns Can you guys please let me know how to do the same Your help is much appreciated. (2 Replies)
Discussion started by: Pratik4891
2 Replies

9. Shell Programming and Scripting

extracting number of rows

if > wc -l data.txt > 100 (meaning there are 100 rows) i want to assgn 100 as n so that if i do >echo n it would give me 100 Thanks (5 Replies)
Discussion started by: johnkim0806
5 Replies

10. Shell Programming and Scripting

SQLLDR :Data not loaded completely

Hi , I am using below control file LOAD DATA APPEND INTO TABLE LSHADMIN.EG TRAILING NULLCOLS ( STUDY CHAR ) and the text file to load data is CACZ885M2301 When I run below command: sqlldr userid=apps/apps control=/home/appsuser/dataload/ctl_file.ctl... (3 Replies)
Discussion started by: Pratiksha Mehra
3 Replies

LEARN ABOUT OPENSOLARIS

auditstat

auditstat(1M)						  System Administration Commands					     auditstat(1M)

NAME

       auditstat - display kernel audit statistics

SYNOPSIS

       auditstat [-c count] [-h numlines] [-i interval] [-n] [-v]

DESCRIPTION

       auditstat displays kernel audit statistics. The fields displayed are as follows:

       aud     The total number of audit records processed by the audit(2) system call.

       ctl     This field is obsolete.

       drop    The total number of audit records that have been dropped. Records are dropped according to the kernel audit policy. See auditon(2),
	       AUDIT_CNT policy for details.

       enq     The total number of audit records put on the kernel audit queue.

       gen     The total number of audit records that have been constructed (not the number written).

       kern    The total number of audit records produced by user processes (as a result of system calls).

       mem     The total number of Kbytes of memory currently in use by the kernel audit module.

       nona    The total number of non-attributable audit records that have been constructed. These are audit records that are not attributable to
	       any particular user.

       rblk    The total number of times that the audit queue has blocked waiting to process audit data.

       tot     The total number of Kbytes of audit data written to the audit trail.

       wblk    The total number of times that user processes blocked on the audit queue at the high water mark.

       wrtn    The  total  number  of audit records written. The difference between enq and wrtn is the number of outstanding audit records on the
	       audit queue that have not been written.

OPTIONS

       -c count       Display the statistics a total of count times. If count is equal to zero, statistics are	displayed  indefinitely.   A  time
		      interval must be specified.

       -h numlines    Display a header for every  numlines of statistics printed. The default is to display the header every 20 lines. If numlines
		      is equal to zero, the header is never displayed.

       -i interval    Display the statistics every interval where interval is the number of seconds to sleep between each collection.

       -n	      Display the number of kernel audit events currently configured.

       -v	      Display the version number of the kernel audit module software.

EXIT STATUS

       auditstat returns 0 upon success and 1 upon failure.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       auditconfig(1M), praudit(1M), bsmconv(1M), audit(2), auditon(2), attributes(5)

NOTES

       The functionality described in this man page is available only if the Basic Security Module (BSM) has been enabled.  See   bsmconv(1M)  for
       more information.

SunOS 5.11							    11 Feb 2008 						     auditstat(1M)
All times are GMT -4. The time now is 10:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy