Thanks both, but I have to implement the expression directly on query and not in post processing. Anyway since I have a large ammount of data, I'll try:
And the reporting back when the query has finished.
---------- Post updated at 07:04 AM ---------- Previous update was at 05:53 AM ----------
This query is For HP-UX 11i server.
I have certain oracle process that are running on my system as below :-
rotmgr 3986 1 0 07:49:33 ? 0:00 oracleedjlive (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
rotmgr 26356 1 0 08:14:32 ? 0:00 oracleedjlive... (4 Replies)
Hi,
I wrote a simple shell script which accepts the input value yearmonth in the format YYYYMM and displays the date as YYYY-MM-DD.Day will be 01 always.Please find the code below
#!/bin/ksh
export yearmonth_date=$1
print_usage() {
echo "usage: ${0##*/} <yearmonth_date> \n" \
... (1 Reply)
Hi,
I have a requirement as below which needs to be done viz UNIX shell script
(1) I have to connect to an Oracle database
(2) Exexute "SELECT field_status from table 1" query on one of the tables.
(3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
How can i modify the below to search for the things i'm looking for during a certain time frame?
select Node, NodeAlias, Summary, Tally, AlertKey, AlertGroup, Manager, Agent from mrtg_alerts where LastOccurrence > '5-Dec-2010' order by Manager desc;
In this particular case, this query is... (3 Replies)
Hi,
I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database.
For instance:
USER CITY
--------- ----------
A CITY_A
B CITY_B
C ... (2 Replies)
Hi Experts,
I have a data with multiple entry , I want to filter PKG= & the last column "00060110" or "00088150" in the output
file:
###############################################################################################
PKG= P8SDB :: VGS = vgP8SOra vgP8SDB1 vgP8S001... (5 Replies)
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
Hii,
I am reading data from files by defining path as *.log etc,
Files names are like app1a_test2_heep.log , cdc2a_test3_heep.log etc
How to configure logstash so that the part of string that is string before underscore (app1a, cdc2a..) should be grepped and added to host field and... (7 Replies)
Discussion started by: Ravi Kishore
7 Replies
LEARN ABOUT V7
iswalnum
ISWALNUM(3) Linux Programmer's Manual ISWALNUM(3)NAME
iswalnum - test for alphanumeric wide character
SYNOPSIS
#include <wctype.h>
int iswalnum(wint_t wc);
DESCRIPTION
The iswalnum() function is the wide-character equivalent of the isalnum(3) function. It tests whether wc is a wide character belonging to
the wide-character class "alnum".
The wide-character class "alnum" is a subclass of the wide-character class "graph", and therefore also a subclass of the wide-character
class "print".
Being a subclass of the wide-character class "print", the wide-character class "alnum" is disjoint from the wide-character class "cntrl".
Being a subclass of the wide-character class "graph", the wide-character class "alnum" is disjoint from the wide-character class "space"
and its subclass "blank".
The wide-character class "alnum" is disjoint from the wide-character class "punct".
The wide-character class "alnum" is the union of the wide-character classes "alpha" and "digit". As such, it also contains the wide-char-
acter class "xdigit".
The wide-character class "alnum" always contains at least the letters 'A' to 'Z', 'a' to 'z' and the digits '0' to '9'.
RETURN VALUE
The iswalnum() function returns nonzero if wc is a wide character belonging to the wide-character class "alnum". Otherwise, it returns
zero.
ATTRIBUTES
For an explanation of the terms used in this section, see attributes(7).
+-----------+---------------+----------------+
|Interface | Attribute | Value |
+-----------+---------------+----------------+
|iswalnum() | Thread safety | MT-Safe locale |
+-----------+---------------+----------------+
CONFORMING TO
POSIX.1-2001, POSIX.1-2008, C99.
NOTES
The behavior of iswalnum() depends on the LC_CTYPE category of the current locale.
SEE ALSO isalnum(3), iswctype(3)COLOPHON
This page is part of release 4.15 of the Linux man-pages project. A description of the project, information about reporting bugs, and the
latest version of this page, can be found at https://www.kernel.org/doc/man-pages/.
GNU 2015-08-08 ISWALNUM(3)