Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Line break in sqlplus output through ksh script
Top Forums Shell Programming and Scripting Line break in sqlplus output through ksh script Post 302995702 by Sumit Arora on Tuesday 11th of April 2017 02:06:57 AM
Old 04-11-2017
Below is the SQL:
Code:
SELECT &&1 || '|' || to_char(sysdate, 'YYYYMMDD') || 'T' ||
        to_char(sysdate, 'HH24MM') || '00' || '|' || item.segment1 || '|' || 'IM' || '|' ||
        substr(item.description, 1, 50) || '|' || item.primary_UOM_Code || '|' || case
          when item.unit_weight > 0 then
           item.unit_weight
          when item.unit_weight <= 0 then
           9999.9999
          else
           9999.999
        end || '|' || NVL(item.weight_uom_code, 'KG') || '|' || 0 || '|' ||
        'USD' || '|' || 'N' || '|' || '' || '|' || '' || '|' || 'E' || '|' || '' || '|' || '' || '|' ||
        replace(glo_buyer.agent_name, '''', '') || '|' || '' || '|' || case
          when length(hts.tariff_code) < 10 THEN
           '1111111111'
          when hts.tariff_code Is Null THEN
           '1111111111'
          else
           hts.tariff_code
        END || '|' || 'M' || '|' || 'XX' || '|' || 'MULTIPLE' || '|' || '' || '|' || case
          when cst.item_cost > 0 then
           cst.item_cost
          when lacst.item_cost > 0 then
           lacst.item_cost
        --when pendingcst.item_cost > 0 then pendingcst.item_cost
          else
           0
        end || '|' ||
       --cst.item_cost||'|'||
        0 || '|' || 'USD' || '|' || 0 || '|' || 0 || '|' || '' || '|' || 0 || '|' || 0 || '|' || '' || '|' || '' || '|' || '' || '|' || 0 || '|' || '' || '|' || 0 || '|' || '' || '|' ||
        glo_buyer.agent_name || '|' || '' || '|' || ''
  FROM apps.mtl_system_items_b item

(more conditions)

we are generating output in .txt format and viewing output in notepad.
Last edited by Don Cragun; 04-11-2017 at 03:28 AM.. Reason: Add CODE and ICODE tags, again.
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

ksh script: 'exit' being treated as 'break 2'

hi, in a korn shell script, has anyone ever seen an 'exit' being treated as a 'break 2'? I have a script which has 3 nested loops. Within the inner most loop, i'm trying to exit the script on a fault condition. instead of exiting, it's acting as a 'break 2' and then continuing on with the... (4 Replies)
Discussion started by: gsatch
4 Replies

2. Shell Programming and Scripting

Need help with ksh script that uses sqlplus, called from PHP

I have a ksh script that connects to sqlplus and dumps the query results into a file. The script works file when I run it from the command line, however, when I call it from PHP using system(), exec(), or shell_exec() commands, the script doesn't seem to run the query. It will create the text file... (7 Replies)
Discussion started by: j2owilson
7 Replies

3. Shell Programming and Scripting

How to pass variable to SQLPLUS in a ksh script?

Hi, I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers. Inside the same script, I am using SQLPLUS to run an Oracle SQL script,... (6 Replies)
Discussion started by: rwunwla
6 Replies

4. UNIX for Advanced & Expert Users

sqlPlus output with new line character

Hi, I have a script which calls a sqlplus command and i'm saving the output in a variable. Z=`sqlplus -s $TC_ORACLE_USER/$TC_ORACLE_PASSWORD@$TC_CONNECT_STRING <<eof set echo off set head off set serveroutput on; set feedback off; select description from period where trunc(sysdate)... (2 Replies)
Discussion started by: decci_7
2 Replies

5. Shell Programming and Scripting

KSH script to run other ksh scripts and output it to a file and/or email

Hi I am new to this Scripting process and would like to know How can i write a ksh script that will call other ksh scripts and write the output to a file and/or email. For example ------- Script ABC ------- a.ksh b.ksh c.ksh I need to call all three scripts execute them and... (2 Replies)
Discussion started by: pacifican
2 Replies

6. Solaris

sqlplus output from ksh.

Hi All, I have the below simple script. It runs just fine by itself when I manually invoke it. But once I put it in the crontab with entry: * * * * * /users/myuser/test.ksh >> /users/myuser/log/test.txt" It does NOT print the returned value ($REMAIN) from the DB!? The result in the... (3 Replies)
Discussion started by: steve701
3 Replies

7. Shell Programming and Scripting

Shell Script (ksh) - SQLPlus query filter using a string variable

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)
Discussion started by: nkm0brm
5 Replies

8. Shell Programming and Scripting

Output result with break line

Hello, I am coding a script to check mysql databases using bash script, I would like to check if the status of a table is not 'OK', will return the table name and do some more actions: check.log table1 OK table2 Some error here table3 ... (5 Replies)
Discussion started by: Abu Rayane
5 Replies

9. UNIX for Beginners Questions & Answers

awk script for pattern match and line break

Hi, I have input which reads like 9089.00 ----- kl jkjjljk lkkk; (909099) 9097.00 ----- HGJJHHJ jcxkjlkjvhvlk jhdkjksdfkhfskd 898.00 ----- HHHH I am trying to do something like this - As soon as I found pattern match "XYZ.00-----" it will insert a line break to the input and will go to... (3 Replies)
Discussion started by: Indra2011
3 Replies

10. Shell Programming and Scripting

Oracle/SQLPlus help - ksh Script calling .sql file not 'pausing' at ACCEPT, can't figure out why

Hi, I am trying to write a script that calls an Oracle SQL file who in turns call another SQL file. This same SQL file has to be run against the same database but using different username and password at each loop. The first SQL file is basically a connection test and it is supposed to sort... (2 Replies)
Discussion started by: newbie_01
2 Replies

LEARN ABOUT NETBSD

menu_driver

MENU_DRIVER(3)						   BSD Library Functions Manual 					    MENU_DRIVER(3)

NAME

     menu_driver -- main menu handling function

LIBRARY

     Curses Menu Library (libmenu, -lmenu)

SYNOPSIS

     #include <menu.h>

     int
     menu_driver(MENU *menu, int c);

DESCRIPTION

     The menu_driver() function is the guts of the menu system.  It takes the commands passed by c parameter and performs the requested action on
     the menu given.  The following commands may be given to the menu driver:

     Command		Action
     REQ_LEFT_ITEM	Sets the new current item to be the item to the left of the current item.
     REQ_RIGHT_ITEM	Sets the new current item to be the item to the rights of the current item.
     REQ_UP_ITEM	Sets the new current item to be the item above the current item.
     REQ_DOWN_ITEM	Sets the new current item to be the item below the current item.
     REQ_SCR_ULINE	Scroll the menu one line towards the bottom of the menu window.  The new current item becomes the item immediately above
			the current item.
     REQ_SCR_DLINE	Scroll the menu one line towards the top of the menu window.  The new current item becomes the item immediately below the
			current item.
     REQ_SCR_DPAGE	Scroll the menu one page towards the bottom of the menu window.
     REQ_SCR_UPAGE	Scroll the menu one page towards the top of the menu window.
     REQ_FIRST_ITEM	Set the current item to be the first item in the menu.
     REQ_LAST_ITEM	Set the current item to be the last item in the menu.
     REQ_NEXT_ITEM	Set the new current item to be the next item in the item array after the current item.
     REQ_PREV_ITEM	Set the new current item to be the item before the current item in the items array.
     REQ_TOGGLE_ITEM	If the item is selectable then toggle the item's value.
     REQ_CLEAR_PATTERN	Clear all the characters currently in the menu's pattern buffer.
     REQ_BACK_PATTERN	Remove the last character from the pattern buffer.
     REQ_NEXT_MATCH	Attempt to find the next item that matches the pattern buffer.
     REQ_PREV_MATCH	Attempt to find the previous item that matches the pattern buffer.
     If menu_driver() is passed a command that is greater than MAX_COMMAND then the command passed is assumed to be a user defined command and
     menu_driver() returns E_UNKNOWN_COMMAND.  Otherwise if the command is a printable character then the character represented by the command is
     placed at the end of the pattern buffer and an attempt is made to match the pattern buffer against the items in the menu.

RETURN VALUES

     The functions return one of the following error values:

     E_OK		The function was successful.
     E_SYSTEM_ERROR	There was a system error during the call.
     E_BAD_ARGUMENT	One or more of the arguments passed to the function was incorrect.
     E_NOT_POSTED	The menu is not posted.
     E_UNKNOWN_COMMAND	The menu driver does not recognize the request passed to it.
     E_NO_MATCH 	The character search failed to find a match.
     E_NOT_CONNECTED	The item is not connected to a menu.
     E_REQUEST_DENIED	The menu driver could not process the request.

SEE ALSO

     curses(3), menus(3)

NOTES

     The header <menu.h> automatically includes both <curses.h> and <eti.h>.

BSD
								September 10, 1999							       BSD
All times are GMT -4. The time now is 02:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy