Page 1 of 1

Select JCL

PostPosted: Mon Nov 25, 2013 4:22 pm
by itamar rocha
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.

Re: Select JCL

PostPosted: Mon Nov 25, 2013 5:18 pm
by enrico-sorichetti
wouldn' t have been better to post in the DB2 section ???

Re: Select JCL

PostPosted: Mon Nov 25, 2013 6:47 pm
by itamar rocha
Could be, but I am using in the jcl.
But I got the necessary informations and I solved the problem.
Thanks.

Re: Select JCL

PostPosted: Mon Nov 25, 2013 7:08 pm
by enrico-sorichetti
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

Re: Select JCL

PostPosted: Mon Nov 25, 2013 7:25 pm
by Robert Sample
Topic moved to DB2 forum -- this is not a JCL issue -- JCL does not use SELECT statements. DB2 uses SELECT statements.

Re: Select JCL

PostPosted: Mon Nov 25, 2013 8:35 pm
by itamar rocha
Ok.

Re: Select JCL

PostPosted: Mon Nov 25, 2013 10:45 pm
by dick scherrer
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.

Re: Select JCL

PostPosted: Tue Nov 26, 2013 3:36 pm
by itamar rocha
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.

Re: Select JCL

PostPosted: Tue Nov 26, 2013 8:56 pm
by dick scherrer
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