Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: awk concatenation issue - SQL generation
Top Forums Shell Programming and Scripting awk concatenation issue - SQL generation Post 302970752 by RudiC on Monday 11th of April 2016 03:04:59 PM
Old 04-11-2016
This may point you in a direction:
Code:
awk '
$4 == "DIRECT"  {IX = $1 OFS $5
                 if ($3 $7 ~ /DATE.*CHAR\(6/)
                        str="SUM(CASE WHEN COALESCE(TO_CHAR("$1"."$2",\47""YYYYMM\47), \47""777707\47)=COALESCE("$5"."$6 ",\47""777707\47) THEN 0 ELSE 1 END) COL_"$6

                 if ($3 $7 ~ /CHAR.*INTEGER/)
                        str="SUM(CASE WHEN COALESCE("$1"."$2",\47""777707\47)=COALESCE("$5"."$6 ",\47""777707\47) THEN 0 ELSE 1 END) COL_"$6

                 a[IX] = (a[IX])?a[IX] "," str:str
                }

END     {for (i in a)   {print "source and target table names are " i
                         print "--------------"
                         print "excerpt of the query is " a[i]
                         print "%%%%%%%%%%%%%%%%%%%%"
                        }
        }
' < file

This User Gave Thanks to RudiC For This Post:
chill3chee
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

SQL Loader Auto Number Generation

Hi all, I have a doubt in SQL Loader. We have SEQUENCE function in SQL Loader or can create Sequence in Oracle database for generating a number sequence for a column while loading data using SQL Loader into table or multiple tables. My requirment is this. For the first run in SQL... (2 Replies)
Discussion started by: vinoth_kumar
2 Replies

2. Shell Programming and Scripting

cannot get logic for concatenation awk

Hello friends, I have a problem in printing an array.. Example if my array line contains 4 elements like following line=0002 , line=202200, line=200002, line= 300313 Now one = sprintf line line line line will concatenate my whole array to one. But I am not sure about the... (7 Replies)
Discussion started by: user_prady
7 Replies

3. Shell Programming and Scripting

String concatenation issue in ksh

Hello All, I'm tryying to concatenate string and variables value in ksh, but i'm unable to do it, can someone please help in rectifying my error, here is the code i have written, #!/usr/bin/ksh -x cat $1 | while read fileline do val1= echo $fileline | awk -F, '{print $1}' val2= echo... (3 Replies)
Discussion started by: arvindcgi
3 Replies

4. Shell Programming and Scripting

Dynamic command line generation with awk

Hi, I'm not an expert in awk but i need a simple script to do this: I'd like to AutoCrop PDF files. I found 2 simple script that combined together could help me to automatize :) The first utiliti is "pdfinfo" that it gives the MediaBox and TrimBox values from the pdf. The pdfinfo output... (8 Replies)
Discussion started by: gbagagli
8 Replies

5. Shell Programming and Scripting

Awk concatenation in different lines

Hi All I have the data as id-number 01 name-id x0 input-id x0 output-id x0 name-id x0 input-id x0 output-id x0 name-id x0 input-id x0 output-id x0 id-number 02 name-id x0 input-id x0 output-id x0 name-id x0 input-id x0 output-id x0 name-id x0 input-id x0 output-id x0 . . I... (4 Replies)
Discussion started by: posner
4 Replies

6. Shell Programming and Scripting

Random word generation with AWK

Hi - I have a word GTTCAGAGTTCTACAGTCCGACGAT I need to extract all the possible "chunks" of 7 or above letter "words" from this. SO, my out put should be GTTCAGA TTCAGAG TCAGAGT CAGAGTTCT TCCGACGAT CAGTCCGACG etc. How can I do that with awk or any other language? I have no... (2 Replies)
Discussion started by: polsum
2 Replies

7. UNIX for Dummies Questions & Answers

awk for concatenation of column values

Hello, I have a table as shown below. I want to concatenate values in col2 and col3 based on a value in col4. 1 X Y A 3 Y Z B 4 A W B 5 T W A If col4 is A, then I want to concatenate col3 with itself. Otherwise it should concateneate col2 with col3. 1 X Y YY 3 Y Z YZ... (10 Replies)
Discussion started by: Gussifinknottle
10 Replies

8. Shell Programming and Scripting

Concatenation in awk not working

Hello I want to achieve the following. However the concatenation is not working mv `ls -ltr *myfile*.log|awk '{print $9}'` `ls -ltr *myfile*.log|awk '{print `date +'%d%m%y%k%M%S'` $9}'` I tried awk '{x=`date +'%d%m%y%k%M%S'` print $x "" $9}' awk '{x=`date +'%d%m%y%k%M%S'`... (2 Replies)
Discussion started by: Chetanz
2 Replies

9. Shell Programming and Scripting

Issue in Concatenation/Joining of lines in a dynamically generated file

Hi, I have a file containing many records delimited by pipe (|). Each record should contain 17 columnns/fields. there are some fields having fields less than 17.So i am extracting those records to a file using the below command awk 'BEGIN {FS="|"} NF !=17 {print}' feedfile.txt... (8 Replies)
Discussion started by: TomG
8 Replies

10. Shell Programming and Scripting

Using awk and grep for sql generation

Hi, I have a file pk.txt which has table related data in following format TableName | PK Employee | id Contact|name,phone,country I have another file desc.txt which lists datatype of each field like this: Table|Field|Type Employee|id|int Contact|name|string Contact|country|string... (7 Replies)
Discussion started by: wahi80
7 Replies

LEARN ABOUT SUNOS

print

print(9E)							Driver Entry Points							 print(9E)

NAME

       print - display a driver message on system console

SYNOPSIS

       #include <sys/types.h>
       #include <sys/errno.h>
       #include <sys/ddi.h>
       #include <sys/sunddi.h>

       int prefixprint(dev_t dev, char *str);

INTERFACE LEVEL

       Architecture independent level 1 (DDI/DKI). This entry point is required for block devices.

PARAMETERS

       dev	Device number.

       str	Pointer to a character string describing the problem.

DESCRIPTION

       The print() routine is called by the kernel when it has detected an exceptional condition (such as out of space) in the device.	To display
       the message on the console, the driver should use the  cmn_err(9F) kernel function. The driver should print  the  message  along  with  any
       driver specific information.

RETURN VALUES

       The  print() routine should return 0 for success, or the appropriate error number.  The	print routine can fail if the driver implemented a
       non-standard  print() routine that attempted to perform error logging, but was unable to complete the logging for whatever reason.

SEE ALSO

       cmn_err(9F)

       Writing Device Drivers

SunOS 5.10							    15 Sep 1992 							 print(9E)
All times are GMT -4. The time now is 01:41 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy