View previous topic :: View next topic
|
Author |
Message |
rahul.shrivastav
New User
Joined: 17 Jun 2008 Posts: 8 Location: CHENNAI
|
|
|
|
I NEED TO CREATE A NEW DATA SET IN ORDER TO RUN SPUFFI . |
|
Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
Online I guess.
When in ,just give a name near something like OUTPUT ==> |
|
Back to top |
|
|
rahul.shrivastav
New User
Joined: 17 Jun 2008 Posts: 8 Location: CHENNAI
|
|
|
|
I need to create a Data Set ..So that i can RUN SPUFFI to fire DB2 SQL Commands to update database |
|
Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
Hoop - tell me - you want to run SPUFI but you don't know the way to create a PDS and inside a member or simply a sequential file.
What is your position in IT? Analyst? Designer?
Sorry no criticism, just to see how to help you? |
|
Back to top |
|
|
rahul.shrivastav
New User
Joined: 17 Jun 2008 Posts: 8 Location: CHENNAI
|
|
|
|
I am into Testing and Need to Update Certain Fields in Database . |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
I am into Testing and Need to Update Certain Fields in Database .
|
For you to be able to do the work in your environment, you need to talk with your seniors/peers or the database support people to have things configured the way you need them in that environment.
2 easy ways to "create a dataset" are using tso/ispf 3.2 to allocate the file or using jcl specifying a disposition of (new,catlg) for the new dataset.
I suspect these are not the answers you need - which is why i suggest talking to the people i mentioned. |
|
Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
Create via ISPF option 3.2 as PS with correct atttributes ( by memroy ) ( LRCEL 80 - CYLS 1 SECONDARY 1- Directory 0 - let the system decides for other attributes)
Then go to ISPF 3.4 and Edit Dataset - write your SQL code and save by F3.
Go to SPUFI option 1, give the Data set as input and run. |
|
Back to top |
|
|
rahul.shrivastav
New User
Joined: 17 Jun 2008 Posts: 8 Location: CHENNAI
|
|
|
|
My Apologes whether i am putting exact description in that.Since i am new to this, so dont have an clear idea.
Ok.. I did created a New Data Set . But when i go to SPUFFI and Press Option 1 , i am getting error as 'DSN NOT VALID SUBSYSTEM ID, COMMAND TERMINATED ****
Any idea, how to eliminate this? |
|
Back to top |
|
|
PeD
Active User
Joined: 26 Nov 2005 Posts: 459 Location: Belgium
|
|
|
|
Go to option D ( defaults) first, then give the SSID of your DB2 system |
|
Back to top |
|
|
rahul.shrivastav
New User
Joined: 17 Jun 2008 Posts: 8 Location: CHENNAI
|
|
|
|
still getting the same error
'DSN NOT VALID SUBSYSTEM ID, COMMAND TERMINATED ****
[/code][/list] |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Is there some reason you have not asked your seniors/peers or the database support people?
You may continue this way for a long time while they could have you set up quickly. |
|
Back to top |
|
|
rahul.shrivastav
New User
Joined: 17 Jun 2008 Posts: 8 Location: CHENNAI
|
|
|
|
Well..i contact one of my peers..he is telling that i need to have ID and subsystems mapped. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Yes, this is why i suggest the support people - you may also need to interact with the security people. It just depends on how your system is administered.
We have no knowledge of your organization/system structure and can provide very little help for this. |
|
Back to top |
|
|
|