Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Take by default zero value when no value present Post 302881925 by nishantrefound on Friday 3rd of January 2014 02:10:27 AM
Old 01-03-2014
Code Take by default zero value when no value present

Code:
group by RQO_ORG
         Union
         select  '4' AS ORG, 0 AS AUTHVOL
           from sysibm.sysdummy1
          union 
         select  '26' AS ORG, 0 AS AUTHVOL
           from sysibm.sysdummy1
          union 
         select  '30' AS ORG, 0 AS AUTHVOL
           from sysibm.sysdummy1
          union 
         select  '61' AS ORG, 0 AS AUTHVOL
           from sysibm.sysdummy1)


Last edited by Don Cragun; 01-03-2014 at 03:41 AM.. Reason: Add CODE tags.
 

10 More Discussions You Might Find Interesting

1. Programming

Getting present working directory

How can I get the present working directory in unix system using c programming and stored it in a string ?? (0 Replies)
Discussion started by: winsonlee
0 Replies

2. Shell Programming and Scripting

check whether 3 files are present

I'm trying to check whether 3 files are existing and send 3 files as attachements. If only two are there then send those two files as attachments. if ; then elif ; then I tired the above given syntax and then it is giving me an error line 11: ' I tried with -a instead of && and... (3 Replies)
Discussion started by: Celvin VK
3 Replies

3. UNIX for Dummies Questions & Answers

To get the lines that are not present in file

Hi I have got two files File1: Row1 Row2 Row3 Row4 File2: Row3 Row4 Now my requirement is search each and every line of file1 in file2 and if the record do not exist in file2 then write that to an output file. Output file should be as below Row1 Row2 (4 Replies)
Discussion started by: sbhuvana20
4 Replies

4. Red Hat

Present LUN in Redhat

Hi, I created a new vdisk and presented it to a BL460c class server. The LUN was successfully created and presented. My problem however is that I am unable to see the newly added LUN on my OS? I have rebooted the box but no joy. Just wondering if you have any ideas on how this can be... (5 Replies)
Discussion started by: Duffs22
5 Replies

5. Shell Programming and Scripting

Search, and add if present

Dear All, I have to find a way to reorganize a table file according to the last column. The input file looks like this: cat Input1.txt: ID:12:23:00Q EU232 2342 234 123 231 aa1;ab2 ID:11:22:00E EU112 1232 211 112 233 ab2;ac3 ID:19:24:00S EU121 569 ... (7 Replies)
Discussion started by: loba
7 Replies

6. How to Post in the The UNIX and Linux Forums

Board not present

Can please somebody tell me what could be the reason for the following error (Unix Motorola Server): /usr/etc/ce3/s374: Board at address 0xff10000 not present - Entry skipped. /dev/lpc2: I/O error I already replaced the board 374 on the server, but I have the same problem. Thank you! (1 Reply)
Discussion started by: dma
1 Replies

7. Shell Programming and Scripting

Add comment if not present

I have a file cat /root/file #import node1 #import node2 import node2 import node4 After sed/awk operation the file should be as follows cat /root/file #import node1 #import node2 #import node2 #import node4 (6 Replies)
Discussion started by: anil510
6 Replies

8. Red Hat

No Mac address present,

I have installed RHEL 6 in my new system. My sytem is physically also connected with network, but after successfully installing it is not detecting the network. I checked, there is no /etc/sysconfig/network file present in my system. I manually created /etc/sysconfig/network file. The problem I... (5 Replies)
Discussion started by: Ankur Goyal
5 Replies

9. AIX

Disk is present but not active

hello, I have an issue with my aix box. the power went down. I got the box back up and can log into it. the datavg drives are not showing as active. How do i make them active. let me know if you need any screenshots let me know. Thanks ---------- Post updated at 09:48 PM ----------... (1 Reply)
Discussion started by: fierfek
1 Replies

10. UNIX for Beginners Questions & Answers

Text not present in file

File 1: AAAAAA-100000 | ID: C110X01 AAAAAA-100000 | ID : P110X01 DDDDDD-8911694 | ID: P110X01 File2:- ------------------------------------------------------------------------ r1111111 | AAAAAA-100000 | 2011-06-16 11:47:33 +0530 (Fri, 16 Jun 2011) | 2 lines Changed paths: A... (9 Replies)
Discussion started by: vikassahalgaur
9 Replies
z80asm(1)							z88 Development Kit							 z80asm(1)

NAME
z88dk-z80asm - Z80 assembler compiler. SYSNOPIS
z88dk-z80asm [options] [ @<modulefile> | {<filename>} ] DESCRIPTION
This manual page documents briefly the z88dk tools. This manual page was written for the Debian GNU/Linux distribution (but may be used by others), because the original program does not have a manual page. z88dk-z80asm is a Z80 assembler cross compiler. Please refer to the z88dk documentation in /usr/share/doc/z88dk-doc/ for the complete description of the system. If /usr/share/doc/z88dk- doc not exists, please install the package z88dk-doc. OPTIONS
-h display help -n defines option to be turned OFF (except -r -R -i -x -D -t -o) -v verbose -l listing file -s symbol table, -m map listing file -r<ORG> Explicit relocation <ORG> defined in hex (ignore ORG in first module) -plus Interpret 'Invoke' as RST 28h -R Generate relocatable code (Automatical relocation before execution) -D<symbol> define symbol as logically TRUE (used for conditional assembly) -b assemble files & link to ORG address. -c split code in 16K banks -d date stamp control, assemble only if source file > object file -a: -b & -d (assemble only updated source files, then link & relo- cate) -o<bin filename> expl. output filename, -g XDEF reloc. addr. from all modules -i<library> include <library> LIB modules with .obj modules during linking -x<library> create library from specified modules ( e.g. with @<modules> ) -t<n> tabulator width for .map, .def, .sym files. Column width is 4 times -t Default options: -nv -nd -nb -nl -s -m -ng -nc -nR -t8 SEE ALSO
z88dk(1), z88dk-zcc(1), z88dk-z80asm(1), z88dk-appmake(1), z88dk-copt(1). AUTHOR
z88dk was written by Dominic Morris <dom@z88dk.org>, and others. z80asm was written by Gunther Strube <gbs@image.dk>. This manual page was written by Krystian Wlosek <tygrys@waw.pdi.net> using exists documentation, for the Debian GNU/Linux system. 01 December 2009 z80asm(1)
All times are GMT -4. The time now is 12:01 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy