Select JCL



IBM's flagship relational database management system

Select JCL

Postby itamar rocha » Mon Nov 25, 2013 4:22 pm

Hello everyone.
Guys I have a jcl and it does a table unload.
In that table have three attribute x, y z ;

x = timestamp and not null;
y = pic S9(3) v usage comp-3 and null;
z = PIC S9(16)V9(2) USAGE COMP-3.

the jcl contains the select below:

Select dateDate(x),
y,
1,
z
from table xpto;

My question is about the number 1, the number 1 means that the attribute is null? If yes , what atributte?
Another question is , the attribute x when I use date ,just ten positons will written , rigtht?

Thank you.
itamar rocha
 
Posts: 41
Joined: Mon Nov 11, 2013 8:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Select JCL

 

Re: Select JCL

Postby enrico-sorichetti » Mon Nov 25, 2013 5:18 pm

wouldn' t have been better to post in the DB2 section ???
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: Select JCL

Postby itamar rocha » Mon Nov 25, 2013 6:47 pm

Could be, but I am using in the jcl.
But I got the necessary informations and I solved the problem.
Thanks.
itamar rocha
 
Posts: 41
Joined: Mon Nov 11, 2013 8:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Select JCL

Postby enrico-sorichetti » Mon Nov 25, 2013 7:08 pm

Could be, but I am using in the jcl.

:o

You are not asking about the content/format of a/some JCL statements (things starting with // )
but about the content/format of the control statements processed by db2,
and that makes it a DB2 question, not a JCL question
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: Select JCL

Postby Robert Sample » Mon Nov 25, 2013 7:25 pm

Topic moved to DB2 forum -- this is not a JCL issue -- JCL does not use SELECT statements. DB2 uses SELECT statements.
Robert Sample
Global moderator
 
Posts: 3367
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 222 times

Re: Select JCL

Postby itamar rocha » Mon Nov 25, 2013 8:35 pm

Ok.
itamar rocha
 
Posts: 41
Joined: Mon Nov 11, 2013 8:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Select JCL

Postby dick scherrer » Mon Nov 25, 2013 10:45 pm

Hello,

Using proper terminology is NOT just Ok . . .

If you want to be taken as a professional, it is extremely imnportant hyou use the correct terminology,

Many new people (and unfortunately quite a few trainers) do not know proper terminology and all they do is get confused or confuse others.

JCL is a "language" and not everything is part of it. Sort control statements, Easytrieve (and other) code, SQL statements, etc are NOT JCL and should not be called JCL.

You will do yourself and your organization a service by making sure the proper terminology is known and used. Or said differently - a Great dis-service to use what amounts to incorrect slang.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Select JCL

Postby itamar rocha » Tue Nov 26, 2013 3:36 pm

Hello,
I am really sorry.
You are right , I have to use another terminology.
In all my next posts I will use the appropriate terminology and thanks for the clues.
itamar rocha
 
Posts: 41
Joined: Mon Nov 11, 2013 8:46 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Select JCL

Postby dick scherrer » Tue Nov 26, 2013 8:56 pm

Hello,

Not to worry :)

We are here to help with things other than technical solutions.
Terminology really is a "biggie". We'll help with this also.

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post