04-22-2009
ok then try this:
loc_TYPE=$(echo $data_type_SQL | awk -F "|" '{print substr($2,1,1)}')
ware_HOUSE=$(echo $data_type_SQL | awk -F "|" '{print substr($3,1,4)}')
local_ID=$(echo $data_type_SQL | awk -F "|" '{print substr($3,1,4)}')
you should also note that even if the size in the database is defined as 4 or 5 or 6, the actual data may be lesser than the defined size.
cheers,
Devaraj Takhellambam
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I'm new to shell scripting. Trying to extract substring using awk script as shown below :
Flag=$1
Length=`echo ${#Flag}`
NewLen=$Length-2
NewFlag=`echo $Flag|awk '{print substr($Flag,0,$NewLen)}'`
echo "New string is : $NewFlag"
exit
When I execute this script the following... (3 Replies)
Discussion started by: abbey
3 Replies
2. UNIX and Linux Applications
If I recall, when I used informix I could do a sql statement like:
SELECT Value from Table WHERE ID in (100,200,300);
How do I do this in Oracle? I believe I am using Oracle 10 if that matters.
Thanks. (1 Reply)
Discussion started by: benefactr
1 Replies
3. Shell Programming and Scripting
I am trying to assign an select statement into a variable. Can someone hel me with this.
example :
a='select * from dual'
echo $a should give me select * from dual
But this is not working. I trying with \ before * and quotes too. (1 Reply)
Discussion started by: rdhanek
1 Replies
4. Shell Programming and Scripting
Hi All,
I have this script below that checks rpm code version to Linux and Solaris servers.
The script is run using arguement ($1) which is server_list.txt. It runs as:
$ ./scriptname server_list.txt
#!/bin/bash
QUERY="/opt/rpm/bin/rpm -qa --queryformat '%{installtime}... (0 Replies)
Discussion started by: linuxgeek
0 Replies
5. Shell Programming and Scripting
i want to select a variable created and use it in a if statement, but not getting the desired results
LINE='device for 0101a01: lpd://172.25.41.111:515'
prt=`echo $LINE | awk '{print $3 }' | cut -c 1-7`
echo $prt
My if statement to select just what i want..
IFS=$":"
while read prt... (11 Replies)
Discussion started by: ggoliath
11 Replies
6. UNIX for Dummies Questions & Answers
I use command-line mode of GRUB to load kernel,
but I can not know how to chose the partition and kernel argument,
as followed :
please tell me how to do deal with ,
thanks! (0 Replies)
Discussion started by: cqlouis
0 Replies
7. Shell Programming and Scripting
Hi I am using a awk command but not getting required o/p.
input file
a.txt
2 ak
3 cb
4 de
5 gh
6 ij
awk program
BEGIN { x=0 }
{if ($1>3) {x=x+1}{print $0} }
END { print "I found " x " line have value more than 3" }
output
2 ak
3 cb
4 de
5 gh
6 ij (3 Replies)
Discussion started by: aaysa123
3 Replies
8. UNIX for Dummies Questions & Answers
Hello everyone,
A simple question which may have a suggested solution:
I am using, and loving, the select command in a ksh93 script on AIX 6.1 to present users with menus.
I have been successful in controlling all of key input by the users, I still have an issue with the RETURN key. When the... (4 Replies)
Discussion started by: gio001
4 Replies
9. Shell Programming and Scripting
Hi
I have run out of ideas as to why this select doesn't work in a script I am writing.
The script sources a file of common functions and I am trying to use a select statement within one of the functions -
PS3="Try? "
select X in CONT EXIT; do
if ]
... (4 Replies)
Discussion started by: steadyonabix
4 Replies
10. Shell Programming and Scripting
On server1 the "id" command works fine and returns "myuser" user as was expected. Below are the details of the good server.
$ id -nu 501
myuser
$ cat /etc/system-release
Red Hat Enterprise Linux Server release 7.6 (Maipo)
$ uname -a
Linux server1 3.10.0-957.el7.x86_64 #1 SMP Thu Oct 4... (10 Replies)
Discussion started by: mohtashims
10 Replies
LEARN ABOUT PHP
php_uname
PHP_UNAME(3) 1 PHP_UNAME(3)
php_uname - Returns information about the operating system PHP is running on
SYNOPSIS
string php_uname ([string $mode = "a"])
DESCRIPTION
php_uname(3) returns a description of the operating system PHP is running on. This is the same string you see at the very top of the
phpinfo(3) output. For the name of just the operating system, consider using the PHP_OS constant, but keep in mind this constant will con-
tain the operating system PHP was built on.
On some older UNIX platforms, it may not be able to determine the current OS information in which case it will revert to displaying the OS
PHP was built on. This will only happen if your uname() library call either doesn't exist or doesn't work.
PARAMETERS
o $mode
-$mode is a single character that defines what information is returned:
o 'a': This is the default. Contains all modes in the sequence "s n r v m".
o 's': Operating system name. eg. FreeBSD.
o 'n': Host name. eg. localhost.example.com.
o 'r': Release name. eg. 5.1.2-RELEASE.
o 'v': Version information. Varies a lot between operating systems.
o 'm': Machine type. eg. i386.
RETURN VALUES
Returns the description, as a string.
EXAMPLES
Example #1
Some php_uname(3) examples
<?php
echo php_uname();
echo PHP_OS;
/* Some possible outputs:
Linux localhost 2.4.21-0.13mdk #1 Fri Mar 14 15:08:06 EST 2003 i686
Linux
FreeBSD localhost 3.2-RELEASE #15: Mon Dec 17 08:46:02 GMT 2001
FreeBSD
Windows NT XN1 5.1 build 2600
WINNT
*/
if (strtoupper(substr(PHP_OS, 0, 3)) === 'WIN') {
echo 'This is a server using Windows!';
} else {
echo 'This is a server not using Windows!';
}
?>
There are also some related Predefined PHP constants that may come in handy, for example:
Example #2
A few OS related constant examples
<?php
// *nix
echo DIRECTORY_SEPARATOR; // /
echo PHP_SHLIB_SUFFIX; // so
echo PATH_SEPARATOR; // :
// Win*
echo DIRECTORY_SEPARATOR; //
echo PHP_SHLIB_SUFFIX; // dll
echo PATH_SEPARATOR; // ;
?>
SEE ALSO
phpversion(3), php_sapi_name(3), phpinfo(3).
PHP Documentation Group PHP_UNAME(3)