Author |
Message |
Topic: Attibutes same as sortin |
satheeshs
Replies: 4
Views: 1973
|
Forum: Job Control Language(JCL) Posted: Thu Jan 11, 2007 3:34 am Subject: Attibutes same as sortin |
If the input file is in DASDs, you can use 'LIKE='i/p file'' parameter while you catalog the o/p dataset.
LIKE will not support tape datasets |
Topic: Change the Sign Using SYNCSORT |
satheeshs
Replies: 1
Views: 1445
|
Forum: Utilities Posted: Tue Jan 09, 2007 4:45 am Subject: Change the Sign Using SYNCSORT |
I would suggest putting your sysin cards 2 spaces after the sysin statement |
Topic: Use ATTN to terminate Function. |
satheeshs
Replies: 9
Views: 9103
|
Forum: Application Programming Posted: Sun Jul 16, 2006 5:55 am Subject: Use ATTN to terminate Function. |
it is probably retrieving data from the tape.
i think pressing shift+Esc is the attention key. i am not sure.
Cheers |
Topic: Easytrieve - invalid file reference error |
satheeshs
Replies: 4
Views: 11426
|
Forum: Application Programming Posted: Tue Jul 11, 2006 9:29 am Subject: Easytrieve - invalid file reference error |
Your JOB statement refers FILEA twice instead of FILEB . You are getting Invalid file reference error because you might be referrring to file in a not found condition
i am sorry it is typo error. ... |
Topic: Easytrieve - invalid file reference error |
satheeshs
Replies: 4
Views: 11426
|
Forum: Application Programming Posted: Tue Jul 11, 2006 9:14 am Subject: Easytrieve - invalid file reference error |
got this
FILEA 4 INPUT
FILEB 3 INPUT
and
A010 -INVALID FILE REFERENCE - FILEB
The output i got is exactly
FILEA 4 INPUT SAM FIX BLK 10 27 ... |
Topic: Easytrieve - invalid file reference error |
satheeshs
Replies: 4
Views: 11426
|
Forum: Application Programming Posted: Tue Jul 11, 2006 9:11 am Subject: Easytrieve - invalid file reference error |
hi all,
i got this 'A010 -INVALID FILE REFERENCE - filename' error
the input file has records
FILEA
0000000001
0000000005
0000000009
0000000013
0000000024
0000000026
0000000029
.
.
.
... |
Topic: Help Regarding SUBSTR function... |
satheeshs
Replies: 10
Views: 4017
|
Forum: Database Posted: Thu Jul 06, 2006 9:48 am Subject: Help Regarding SUBSTR function... |
Thanks kolusu |
Topic: Help Regarding SUBSTR function... |
satheeshs
Replies: 10
Views: 4017
|
Forum: Database Posted: Thu Jul 06, 2006 9:43 am Subject: Help Regarding SUBSTR function... |
in the first plaec itself.
say -4578
should come as
-7845 |
Topic: Help Regarding SUBSTR function... |
satheeshs
Replies: 10
Views: 4017
|
Forum: Database Posted: Thu Jul 06, 2006 9:23 am Subject: Help Regarding SUBSTR function... |
Thanks kolusu.
it works. in my table, it has only positive numbers. so no probs.
if possible could you tell me to handle negative numbers, i could learn! |
Topic: Help Regarding SUBSTR function... |
satheeshs
Replies: 10
Views: 4017
|
Forum: Database Posted: Thu Jul 06, 2006 9:03 am Subject: Help Regarding SUBSTR function... |
putting a space in between is fine, but a number got truncated.
The expected result should be
54 473028999
but it is coming as
95 47302899
that's why i feel doubt about the space between t ... |
Topic: Help Regarding SUBSTR function... |
satheeshs
Replies: 10
Views: 4017
|
Forum: Database Posted: Thu Jul 06, 2006 8:50 am Subject: Help Regarding SUBSTR function... |
Thanks all,
i apologize for posted this question in this forum. i am very new to this forum.
i tried with SUBSTR(char(var1),10,2) concat SUBSTR(char(var1),01,9)
but still is not giving the exp ... |
Topic: Help Regarding SUBSTR function... |
satheeshs
Replies: 10
Views: 4017
|
Forum: Database Posted: Thu Jul 06, 2006 8:31 am Subject: Help Regarding SUBSTR function... |
hi all,
i need help regarding SUBSTR function.
i want to select a column in a db2 table which is Decimal(11,0) in the way
that last 2 characters to be at first and 1st 9 characters concatenated wit ... |
Topic: How to send an already executed job to DSAR ? |
satheeshs
Replies: 0
Views: 915
|
Forum: TSO and ISPF Posted: Thu Jul 06, 2006 8:22 am Subject: How to send an already executed job to DSAR ? |
How to send an already executed job to DSAR ? What command has to be given for that? |
|