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
Moose::Meta::TypeConstraint::Union(3)			User Contributed Perl Documentation		     Moose::Meta::TypeConstraint::Union(3)

NAME
Moose::Meta::TypeConstraint::Union - A union of Moose type constraints VERSION
version 2.0604 DESCRIPTION
This metaclass represents a union of type constraints. A union takes multiple type constraints, and is true if any one of its member constraints is true. INHERITANCE
"Moose::Meta::TypeConstraint::Union" is a subclass of Moose::Meta::TypeConstraint. Moose::Meta::TypeConstraint::Union->new(%options) This creates a new class type constraint based on the given %options. It takes the same options as its parent. It also requires an additional option, "type_constraints". This is an array reference containing the Moose::Meta::TypeConstraint objects that are the members of the union type. The "name" option defaults to the names all of these member types sorted and then joined by a pipe (|). The constructor sets the implementation of the constraint so that is simply calls "check" on the newly created object. Finally, the constructor also makes sure that the object's "coercion" attribute is a Moose::Meta::TypeCoercion::Union object. $constraint->type_constraints This returns the array reference of "type_constraints" provided to the constructor. $constraint->parent This returns the nearest common ancestor of all the components of the union. $constraint->check($value) $constraint->validate($value) These two methods simply call the relevant method on each of the member type constraints in the union. If any type accepts the value, the value is valid. With "validate" the error message returned includes all of the error messages returned by the member type constraints. $constraint->equals($type_name_or_object) A type is considered equal if it is also a union type, and the two unions have the same member types. $constraint->find_type_for($value) This returns the first member type constraint for which "check($value)" is true, allowing you to determine which of the Union's member type constraints a given value matches. $constraint->is_a_type_of($type_name_or_object) This returns true if all of the member type constraints return true for the "is_a_type_of" method. $constraint->is_subtype_of This returns true if all of the member type constraints return true for the "is_a_subtype_of" method. $constraint->create_child_type(%options) This returns a new Moose::Meta::TypeConstraint object with the type as its parent. BUGS
See "BUGS" in Moose for details on reporting bugs. AUTHOR
Moose is maintained by the Moose Cabal, along with the help of many contributors. See "CABAL" in Moose and "CONTRIBUTORS" in Moose for details. COPYRIGHT AND LICENSE
This software is copyright (c) 2012 by Infinity Interactive, Inc.. This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself. perl v5.16.2 2012-09-19 Moose::Meta::TypeConstraint::Union(3)
All times are GMT -4. The time now is 02:07 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy