Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script help
Top Forums Shell Programming and Scripting Script help Post 302240456 by mohan705 on Friday 26th of September 2008 12:13:27 AM
Old 09-26-2008
Hi
Its working but its not giving the status of first table even if difference .


a.sh file1.txt file2.txt

xx1
xx2 is ok


example

Code:
data length of Cd its different from xx1 in both databases ,its not 

file1.txt

CREATE  TABLE XX1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
Id INTEGER NOT NULL,
Cd CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Category_Cd VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
XX_Dt DATE FORMAT 'YYYY-MM-DD' NOT NULL,
Ind CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
XX_Dt1 DATE FORMAT 'YYYY-MM-DD'
);
-----------------------------

CREATE  TABLE XX2 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
Id INTEGER NOT NULL,
Cd CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Category_Cd VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
XX_Dt DATE FORMAT 'YYYY-MM-DD' NOT NULL,
Ind CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
XX_Dt1 DATE FORMAT 'YYYY-MM-DD'
);


file2.txt

CREATE  TABLE XX1 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
Id INTEGER NOT NULL,
Cd CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Category_Cd VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
XX_Dt DATE FORMAT 'YYYY-MM-DD' NOT NULL,
Ind CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
XX_Dt1 DATE FORMAT 'YYYY-MM-DD'
);
-----------------------------

CREATE  TABLE XX2 ,NO FALLBACK ,
NO BEFORE JOURNAL,
NO AFTER JOURNAL,
CHECKSUM = DEFAULT
(
Id INTEGER NOT NULL,
Cd CHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
Category_Cd VARCHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
XX_Dt DATE FORMAT 'YYYY-MM-DD' NOT NULL,
Ind CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC,
XX_Dt1 DATE FORMAT 'YYYY-MM-DD'
);

Thanks,
MR
 

5 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

create a shell script that calls another script and and an awk script

Hi guys I have a shell script that executes sql statemets and sends the output to a file.the script takes in parameters executes sql and sends the result to an output file. #!/bin/sh echo " $2 $3 $4 $5 $6 $7 isql -w400 -U$2 -S$5 -P$3 << xxx use $4 go print"**Changes to the table... (0 Replies)
Discussion started by: magikminox
0 Replies

2. Shell Programming and Scripting

Script will keep checking running status of another script and also restart called script at night

I am using blow script :-- #!/bin/bash FIND=$(ps -elf | grep "snmp_trap.sh" | grep -v grep) #check snmp_trap.sh is running or not if then # echo "process found" exit 0; else echo "process not found" exec /home/Ketan_r /snmp_trap.sh 2>&1 & disown -h ... (1 Reply)
Discussion started by: ketanraut
1 Replies

3. UNIX for Dummies Questions & Answers

Calling a script from master script to get value from called script

I am trying to call a script(callingscript.sh) from a master script(masterscript.sh) to get string type value from calling script to master script. I have used scripts mentioned below. #masterscript.sh ./callingscript.sh echo $fileExist #callingscript.sh echo "The script is called"... (2 Replies)
Discussion started by: Raj Roy
2 Replies

4. Shell Programming and Scripting

Shell script works fine as a standalone script but not as part of a bigger script

Hello all, I am facing a weird issue while executing a code below - #!/bin/bash cd /wload/baot/home/baotasa0/sandboxes_finance/ext_ukba_bde/pset sh UKBA_publish.sh UKBA 28082015 3 if then echo "Param file conversion for all the areas are completed, please check in your home directory"... (2 Replies)
Discussion started by: ektubbe
2 Replies

5. Shell Programming and Scripting

How to block first bash script until second bash script script launches web server/site?

I'm new to utilities like socat and netcat and I'm not clear if they will do what I need. I have a "compileDeployStartWebServer.sh" script and a "StartBrowser.sh" script that are started by emacs/elisp at the same time in two different processes. I'm using Cygwin bash on Windows 10. My... (3 Replies)
Discussion started by: siegfried
3 Replies

LEARN ABOUT CENTOS

locale::recodedata::ebcdic_es_a

Locale::RecodeData::EBCDIC_ES_A(3)			User Contributed Perl Documentation			Locale::RecodeData::EBCDIC_ES_A(3)

NAME

       Locale::RecodeData::EBCDIC_ES_A - Conversion routines for EBCDIC_ES_A

SYNOPSIS

       This module is internal to libintl.  Do not use directly!

DESCRIPTION

       This module is generated and contains the conversion tables and routines for EBCDIC-ES-A.

COMMENTS

       The following comments have been extracted from the original charmap:

	version: 1.0
	 source: IBM 3270 Char Set Ref Ch 10, GA27-2837-9, April 1987

       Please note that aliases listed above are not necessarily valid!

CHARACTER TABLE

       The following table is sorted in the same order as the original charmap.  All character codes are in hexadecimal.  Please read 'ISO-10646'
       as 'ISO-10646-UCS4'.

	Local | ISO-10646 | Description
       -------+-----------+-------------------------------------------------
	   00 |  00000000 | NULL (NUL)
	   01 |  00000001 | START OF HEADING (SOH)
	   02 |  00000002 | START OF TEXT (STX)
	   03 |  00000003 | END OF TEXT (ETX)
	   04 |  0000009C | STRING TERMINATOR (ST)
	   05 |  00000009 | CHARACTER TABULATION (HT)
	   06 |  00000086 | START OF SELECTED AREA (SSA)
	   07 |  0000007F | DELETE (DEL)
	   08 |  00000097 | END OF GUARDED AREA (EPA)
	   09 |  0000008D | REVERSE LINE FEED (RI)
	   0A |  0000008E | SINGLE-SHIFT TWO (SS2)
	   0B |  0000000B | LINE TABULATION (VT)
	   0C |  0000000C | FORM FEED (FF)
	   0D |  0000000D | CARRIAGE RETURN (CR)
	   0E |  0000000E | SHIFT OUT (SO)
	   0F |  0000000F | SHIFT IN (SI)
	   10 |  00000010 | DATALINK ESCAPE (DLE)
	   11 |  00000011 | DEVICE CONTROL ONE (DC1)
	   12 |  00000012 | DEVICE CONTROL TWO (DC2)
	   13 |  00000013 | DEVICE CONTROL THREE (DC3)
	   14 |  0000009D | OPERATING SYSTEM COMMAND (OSC)
	   15 |  00000085 | NEXT LINE (NEL)
	   16 |  00000008 | BACKSPACE (BS)
	   17 |  00000087 | END OF SELECTED AREA (ESA)
	   18 |  00000018 | CANCEL (CAN)
	   19 |  00000019 | END OF MEDIUM (EM)
	   1A |  00000092 | PRIVATE USE TWO (PU2)
	   1B |  0000008F | SINGLE-SHIFT THREE (SS3)
	   1C |  0000001C | FILE SEPARATOR (IS4)
	   1D |  0000001D | GROUP SEPARATOR (IS3)
	   1E |  0000001E | RECORD SEPARATOR (IS2)
	   1F |  0000001F | UNIT SEPARATOR (IS1)
	   20 |  00000080 | PADDING CHARACTER (PAD)
	   21 |  00000081 | HIGH OCTET PRESET (HOP)
	   22 |  00000082 | BREAK PERMITTED HERE (BPH)
	   23 |  00000083 | NO BREAK HERE (NBH)
	   24 |  00000084 | INDEX (IND)
	   25 |  0000000A | LINE FEED (LF)
	   26 |  00000017 | END OF TRANSMISSION BLOCK (ETB)
	   27 |  0000001B | ESCAPE (ESC)
	   28 |  00000088 | CHARACTER TABULATION SET (HTS)
	   29 |  00000089 | CHARACTER TABULATION WITH JUSTIFICATION (HTJ)
	   2A |  0000008A | LINE TABULATION SET (VTS)
	   2B |  0000008B | PARTIAL LINE FORWARD (PLD)
	   2C |  0000008C | PARTIAL LINE BACKWARD (PLU)
	   2D |  00000005 | ENQUIRY (ENQ)
	   2E |  00000006 | ACKNOWLEDGE (ACK)
	   2F |  00000007 | BELL (BEL)
	   30 |  00000090 | DEVICE CONTROL STRING (DCS)
	   31 |  00000091 | PRIVATE USE ONE (PU1)
	   32 |  00000016 | SYNCHRONOUS IDLE (SYN)
	   33 |  00000093 | SET TRANSMIT STATE (STS)
	   34 |  00000094 | CANCEL CHARACTER (CCH)
	   35 |  00000095 | MESSAGE WAITING (MW)
	   36 |  00000096 | START OF GUARDED AREA (SPA)
	   37 |  00000004 | END OF TRANSMISSION (EOT)
	   38 |  00000098 | START OF STRING (SOS)
	   39 |  00000099 | SINGLE GRAPHIC CHARACTER INTRODUCER (SGCI)
	   3A |  0000009A | SINGLE CHARACTER INTRODUCER (SCI)
	   3B |  0000009B | CONTROL SEQUENCE INTRODUCER (CSI)
	   3C |  00000014 | DEVICE CONTROL FOUR (DC4)
	   3D |  00000015 | NEGATIVE ACKNOWLEDGE (NAK)
	   3E |  0000009E | PRIVACY MESSAGE (PM)
	   3F |  0000001A | SUBSTITUTE (SUB)
	   40 |  00000020 | SPACE
	   4A |  000000A2 | CENT SIGN
	   4B |  0000002E | FULL STOP
	   4C |  0000003C | LESS-THAN SIGN
	   4D |  00000028 | LEFT PARENTHESIS
	   4E |  0000002B | PLUS SIGN
	   4F |  0000007C | VERTICAL LINE
	   50 |  00000026 | AMPERSAND
	   5A |  00000021 | EXCLAMATION MARK
	   5B |  000020A7 | PESETA SIGN
	   5C |  0000002A | ASTERISK
	   5D |  00000029 | RIGHT PARENTHESIS
	   5E |  0000003B | SEMICOLON
	   5F |  000000AC | NOT SIGN
	   60 |  0000002D | HYPHEN-MINUS
	   61 |  0000002F | SOLIDUS
	   6A |  000000A6 | BROKEN BAR
	   6B |  0000002C | COMMA
	   6C |  00000025 | PERCENT SIGN
	   6D |  0000005F | LOW LINE
	   6E |  0000003E | GREATER-THAN SIGN
	   6F |  0000003F | QUESTION MARK
	   7A |  0000003A | COLON
	   7B |  000000D1 | LATIN CAPITAL LETTER N WITH TILDE
	   7C |  00000040 | COMMERCIAL AT
	   7D |  00000027 | APOSTROPHE
	   7E |  0000003D | EQUALS SIGN
	   7F |  000000F1 | LATIN SMALL LETTER N WITH TILDE
	   81 |  00000061 | LATIN SMALL LETTER A
	   82 |  00000062 | LATIN SMALL LETTER B
	   83 |  00000063 | LATIN SMALL LETTER C
	   84 |  00000064 | LATIN SMALL LETTER D
	   85 |  00000065 | LATIN SMALL LETTER E
	   86 |  00000066 | LATIN SMALL LETTER F
	   87 |  00000067 | LATIN SMALL LETTER G
	   88 |  00000068 | LATIN SMALL LETTER H
	   89 |  00000069 | LATIN SMALL LETTER I
	   91 |  0000006A | LATIN SMALL LETTER J
	   92 |  0000006B | LATIN SMALL LETTER K
	   93 |  0000006C | LATIN SMALL LETTER L
	   94 |  0000006D | LATIN SMALL LETTER M
	   95 |  0000006E | LATIN SMALL LETTER N
	   96 |  0000006F | LATIN SMALL LETTER O
	   97 |  00000070 | LATIN SMALL LETTER P
	   98 |  00000071 | LATIN SMALL LETTER Q
	   99 |  00000072 | LATIN SMALL LETTER R
	   A2 |  00000073 | LATIN SMALL LETTER S
	   A3 |  00000074 | LATIN SMALL LETTER T
	   A4 |  00000075 | LATIN SMALL LETTER U
	   A5 |  00000076 | LATIN SMALL LETTER V
	   A6 |  00000077 | LATIN SMALL LETTER W
	   A7 |  00000078 | LATIN SMALL LETTER X
	   A8 |  00000079 | LATIN SMALL LETTER Y
	   A9 |  0000007A | LATIN SMALL LETTER Z
	   C1 |  00000041 | LATIN CAPITAL LETTER A
	   C2 |  00000042 | LATIN CAPITAL LETTER B
	   C3 |  00000043 | LATIN CAPITAL LETTER C
	   C4 |  00000044 | LATIN CAPITAL LETTER D
	   C5 |  00000045 | LATIN CAPITAL LETTER E
	   C6 |  00000046 | LATIN CAPITAL LETTER F
	   C7 |  00000047 | LATIN CAPITAL LETTER G
	   C8 |  00000048 | LATIN CAPITAL LETTER H
	   C9 |  00000049 | LATIN CAPITAL LETTER I
	   D1 |  0000004A | LATIN CAPITAL LETTER J
	   D2 |  0000004B | LATIN CAPITAL LETTER K
	   D3 |  0000004C | LATIN CAPITAL LETTER L
	   D4 |  0000004D | LATIN CAPITAL LETTER M
	   D5 |  0000004E | LATIN CAPITAL LETTER N
	   D6 |  0000004F | LATIN CAPITAL LETTER O
	   D7 |  00000050 | LATIN CAPITAL LETTER P
	   D8 |  00000051 | LATIN CAPITAL LETTER Q
	   D9 |  00000052 | LATIN CAPITAL LETTER R
	   E2 |  00000053 | LATIN CAPITAL LETTER S
	   E3 |  00000054 | LATIN CAPITAL LETTER T
	   E4 |  00000055 | LATIN CAPITAL LETTER U
	   E5 |  00000056 | LATIN CAPITAL LETTER V
	   E6 |  00000057 | LATIN CAPITAL LETTER W
	   E7 |  00000058 | LATIN CAPITAL LETTER X
	   E8 |  00000059 | LATIN CAPITAL LETTER Y
	   E9 |  0000005A | LATIN CAPITAL LETTER Z
	   F0 |  00000030 | DIGIT ZERO
	   F1 |  00000031 | DIGIT ONE
	   F2 |  00000032 | DIGIT TWO
	   F3 |  00000033 | DIGIT THREE
	   F4 |  00000034 | DIGIT FOUR
	   F5 |  00000035 | DIGIT FIVE
	   F6 |  00000036 | DIGIT SIX
	   F7 |  00000037 | DIGIT SEVEN
	   F8 |  00000038 | DIGIT EIGHT
	   F9 |  00000039 | DIGIT NINE
	   FF |  0000009F | APPLICATION PROGRAM COMMAND (APC)

AUTHOR

       Copyright (C) 2002-2009, Guido Flohr <guido@imperia.net>, all rights reserved.  See the source code for details.

       This software is contributed to the Perl community by Imperia (<http://www.imperia.net/>).

SEE ALSO

       Locale::RecodeData(3), Locale::Recode(3), perl(1)

POD ERRORS

       Hey! The above document had some coding errors, which are explained below:

       Around line 942:
	   =cut found outside a pod block.  Skipping to next block.

perl v5.16.3							    2014-06-10					Locale::RecodeData::EBCDIC_ES_A(3)
All times are GMT -4. The time now is 03:20 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy