MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 13 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: Attibutes same as sortin
satheeshs

Replies: 4
Views: 1973

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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?
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group