Take by default zero value when no value present


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Take by default zero value when no value present
# 1  
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 04:41 AM.. Reason: Add CODE tags.
# 2  
Old 01-03-2014
I see a database query. I don't see sample output or desired output. What are you trying to do that your current query isn't doing for you?
# 3  
Old 01-03-2014
On a further note, the query seems to be syntactically flawed, as the closing bracket in the last line is nowhere opened before and there is no ending semicolon, which is required as a line-ending in SQL.

I hope this helps.

bakunin
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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
Login or Register to Ask a Question