Sponsored Content
Full Discussion: Problem with tabs expansion
Top Forums Shell Programming and Scripting Problem with tabs expansion Post 302457677 by dortoh on Tuesday 28th of September 2010 02:10:52 PM
Old 09-28-2010
@vbe, Here is the script, nothing fancy

Code:
set termout off;
set linesize 1938;
set pagesize 0;
set trims off;
set feedback off;

select
CASE WHEN col1 IS NULL THEN rpad(' ', 1) ELSE rpad(trim(col1), 1) END ||
CASE WHEN col2 IS NULL THEN rpad(' ', 9) ELSE rpad(trim(col2), 9) END ||
CASE WHEN col3 IS NULL THEN rpad(' ', 12) ELSE rpad(trim(col3), 12) END ||
CASE WHEN col4 IS NULL THEN rpad(' ', 9) ELSE rpad(trim(col4), 9) END ||
CASE WHEN col5 IS NULL THEN rpad(' ', 12) ELSE rpad(trim(col5), 12) END ||
CASE WHEN col6 IS NULL THEN rpad(' ', 33) ELSE rpad(trim(col6), 33) END x
from test_table
where col = '99';

 exit;

@ jim mcnamara
I'm relatively new to UNIX, can you spool to a UNIX directory from within a SQL script? If so, how? That's what I wanted to do in the first place but my co-workers said it's not possible.

Thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Pattern expansion problem

All, I have a shell script which executes the below command find $1 -name $2 -print > ${Backup}/FileFind.txt I have $2 sometimes coming with the below values. .* When I go to the log after the execution of the script, .* gets expanded to .developer.adm instead of searching for all... (5 Replies)
Discussion started by: njoshi
5 Replies

2. Shell Programming and Scripting

~ expansion in printf

Hi, I have a script that at one point prints to a file as follows: printf -- $2 > ~/.mydir/$1 The idea is to print to a hidden directory .mydir in my home directory. I've already sanitized the inputs and $1 is in the format path1/path2/filename and $2 is some user input. When I run this... (2 Replies)
Discussion started by: Rledley
2 Replies

3. UNIX for Dummies Questions & Answers

sudo and expansion

Hi there, Can anyone explain me the following behavior? hfserver:~# ls -l /home/cronlogs/mysqldump* -rw-r--r-- 1 root root 10658464 2009-01-18 03:00 /home/cronlogs/mysqldump_20090118030002 -rw-r--r-- 1 root root 10651035 2009-01-19 03:00 /home/cronlogs/mysqldump_20090119030001 -rw-r--r-- 1... (4 Replies)
Discussion started by: chebarbudo
4 Replies

4. Shell Programming and Scripting

Brace expansion problem in Bash

I have a script that takes an option for server pools to run the script against. The option is given as a comma separated list (ie, -p 201,204,301). I'm using eval and brace expansion to get those pool numbers into an array. It works fine unless only 1 pool number is given. Here's the code: ... (5 Replies)
Discussion started by: mglenney
5 Replies

5. UNIX for Dummies Questions & Answers

Problem with White spaces and tabs

Hi All, I am facing issues converting white spaces and tabs together in a file I am reading. Here is the command I am trying: tr -s ' '@ | sort -t@ +1n filename I guess the problem is that it is not converting the tabs to another delimiter. Also, I am supposed to accomplish this only using... (5 Replies)
Discussion started by: sh_kk
5 Replies

6. Shell Programming and Scripting

Need to print the expansion of the found string (the expansion is beween two delimiters '-' , '||'

Hi , could anyone help me out with this problem. sample.txt has this content : u001- this is used for project1 || u002- this is used for p2|| not to be printed u003- this is used for project3 || u004- this is used for p4 || u005- this is used for project5 || u006- this is used for p6... (9 Replies)
Discussion started by: Balaji PK
9 Replies

7. UNIX for Dummies Questions & Answers

Rewriting line with tabs creating problem

Hi I have an input file which have random file in between.I have to manipulate each line and replace the character from position 5-10 with XXXXXX. But when I am writing this to on output file the tabs in between gets converted to normal space. Input file : 14207531131040896334R108 ... (4 Replies)
Discussion started by: akashtcs
4 Replies

8. UNIX for Dummies Questions & Answers

Expansion within cp

I have a bunch of files which I need to transfer to another location... and some of these I need to skip. For e.g. let us say the files are: cust_abc.dat cust_xyz.dat cust_def.dat and I only want to move the first two. I want to do something like: cp cust_.dat <target> ... (1 Reply)
Discussion started by: jawsnnn
1 Replies

9. Shell Programming and Scripting

Tilde expansion

(Using Bash 4.4) When I write something like dir="~/dox" ls $dir then I get the message that the directory '~/docs' does not exist. I understand that the tilde is not expanded at the time of the above assignment because of the quotes. But why is it not expanded at the time when the ls command is... (2 Replies)
Discussion started by: Ralph
2 Replies

10. Shell Programming and Scripting

Use parameter expansion over a parameter expansion in bash.

Hello All, Could you please do help me here as I would like to perform parameter expansion in shell over a parameter expansion. Let's say I have following variable. path="/var/talend/nat/cdc" Now to get only nat I could do following. path1="${path%/*}" path1="${path1##*/}" Here... (8 Replies)
Discussion started by: RavinderSingh13
8 Replies
MOKA(1)                                                      CAO-VLSI Reference Manual                                                     MOKA(1)

NAME
MOKA - Model checker ancestor ORIGIN
This software belongs to the ALLIANCE CAD SYSTEM developed by the ASIM team at LIP6 laboratory of Universite Pierre et Marie CURIE, in Paris, France. Web : http://asim.lip6.fr/recherche/alliance/ E-mail : alliance-users@asim.lip6.fr SYNOPSIS
moka [-VDB] fsm_filename ctl_filename DESCRIPTION
moka is a CTL model checker. Made to run on FSM or RTL descriptions, moka supports the same VHDL subset as syf or boom (for further informations about this subset see SYF(1), BOOM(1), FSM(5), VBE(5) ). Nevertheless moka imposes that each register of the behavioral description have the same clock condi- tion and that there are no tristate or multiplexed buses. In particular VHDL type MUX_BIT and WOR_BIT aren't not supported. First of all moka build the fonction transition of the FSM using a Reduced Ordered Binary Decision Diagrams representation. It then applies the initial conditions to find the first state (keyword INITIAL and/or RESET_COND in the CTL(5) file format). After it computes a symbolic simulation of the FSM in order to find all reachable states. This computation takes into account the assump- tions conditions (ASSUME keyword in the CTL(5) file format). moka finally verifies one by one each CTL formulae. (see CTL(5) for CTL file format details). CTL OPERATORS
For each CTL sub-expression moka will return the set of states that verifies the formula. For example EX(p) will return the set of reach- able states that verifies EX(p). CTL operators : EX(p) : returns all states which have almost one primary state successor that verifies p. EU(p,q) : returns all states that are the root of almost one path, such that p is true until q is always true. EG(p) : returns all states that are the root of almost one path, such that p is always true. AX(p) : returns all states which have all their primary state successor that verifies p. AU(p,q) : returns all states that are the root of only pathes from which p is true until q is always true. AG(p) : returns all states that are the root of only pathes, such that p is always true. ENVIRONMENT VARIABLES
MBK_WORK_LIB gives the path for the description and the CTL file. The default value is the current directory. MBK_CATA_LIB gives some auxiliary pathes for the descriptions and the CTL file. The default value is the current directory. OPTIONS
-V Sets verbose mode on. Each step of the model checking is displayed on the standard output. -D Sets debug mode on. Each step of the model checking is detailed on the standard output. In particular all states set are displayed for each CTL sub-expression. -B The input file is a VHDL description using the Alliance VHDL subset (see VBE(5) file format). FSM EXAMPLE
-- A multi fsm example ENTITY example is PORT ( ck : in BIT; data_in : in BIT; reset : in BIT; data_out : out BIT ); END example; ARCHITECTURE FSM OF example is TYPE A_ETAT_TYPE IS (A_E0, A_E1); SIGNAL A_NS, A_CS : A_ETAT_TYPE; TYPE B_ETAT_TYPE IS (B_E0, B_E1); SIGNAL B_NS, B_CS : B_ETAT_TYPE; --PRAGMA CURRENT_STATE A_CS FSM_A --PRAGMA NEXT_STATE A_NS FSM_A --PRAGMA CLOCK ck FSM_A --PRAGMA FIRST_STATE A_E0 FSM_A --PRAGMA CURRENT_STATE B_CS FSM_B --PRAGMA NEXT_STATE B_NS FSM_B --PRAGMA CLOCK ck FSM_B --PRAGMA FIRST_STATE B_E0 FSM_B SIGNAL ACK, REQ, DATA_INT : BIT; BEGIN A_1 : PROCESS ( A_CS, ACK ) BEGIN IF ( reset = '1' ) THEN A_NS <= A_E0; DATA_OUT <= '0'; REQ <= '0'; ELSE CASE A_CS is WHEN A_E0 => IF ( ACK ='1') THEN A_NS <= A_E1; ELSE A_NS <= A_E0; END IF; DATA_OUT <= '0'; REQ <= '1'; WHEN A_E1 => IF ( ACK ='1') THEN A_NS <= A_E1; ELSE A_NS <= A_E0; END IF; DATA_OUT <= DATA_INT; REQ <= '0'; END CASE; END IF; END PROCESS A_1; A_2 : PROCESS( ck ) BEGIN IF ( ck = '1' AND NOT ck'STABLE ) THEN A_CS <= A_NS; END IF; END PROCESS A_2; ------- B_1 : PROCESS ( B_CS, ACK ) BEGIN IF ( reset = '1' ) THEN B_NS <= B_E0; DATA_INT <= '0'; ACK <= '0'; ELSE CASE B_CS is WHEN B_E0 => IF ( REQ ='1') THEN B_NS <= B_E1; ELSE B_NS <= B_E0; END IF; DATA_INT <= '0'; ACK <= '0'; WHEN B_E1 => IF ( REQ ='1') THEN B_NS <= B_E1; ELSE B_NS <= B_E0; END IF; DATA_INT <= DATA_IN; ACK <= '1'; END CASE; END IF; END PROCESS B_1; B_2 : PROCESS( ck ) BEGIN IF ( ck = '1' AND NOT ck'STABLE ) THEN B_CS <= B_NS; END IF; END PROCESS B_2; END FSM; CTL EXAMPLE
-- A CTL file example TYPE A_ETAT_TYPE IS (A_E0, A_E1); TYPE B_ETAT_TYPE IS (B_E0, B_E1); VARIABLE A_NS, A_CS : A_ETAT_TYPE; VARIABLE B_NS, B_CS : B_ETAT_TYPE; VARIABLE ck : BIT; VARIABLE data_in : BIT; VARIABLE data_out : BIT; VARIABLE reset : BIT; VARIABLE ack : BIT; VARIABLE req : BIT; RESET_COND init1 := (reset='1'); ASSUME ass1 := (reset='0'); begin prop1 : EX( ack='1' ); prop2 : AG( req -> AF( ack ) ); prop4 : AU( req='1', ack='1'); end; MOKA EXAMPLE
moka -V example example SEE ALSO
syf (1), fsp (1), fsm (5), ctl (5), vbe(5). BUG REPORT
This tool is under development at the ASIM department of the LIP6 laboratory. We need your feedback to improve documentation and tools. ASIM
/LIP6 August 5, 2002 MOKA(1)
All times are GMT -4. The time now is 07:23 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy