IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Error while inserting segment in existing IMS database


IBM Mainframe Forums -> IMS DB/DC
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
nehakher

New User


Joined: 14 Oct 2009
Posts: 3
Location: mumbai

PostPosted: Wed Oct 14, 2009 10:58 am
Reply with quote

Hi

I need to insert a segment in IMS database however while inserting using the below mentioned code it throws an erroer of invalid syntax:

DO DBD=dbdname
GHU SSA=SACCOUNT(KACCTNUMEQC'37429000152')
IOAREA POS=1,C' '
ISRT SSA=SFNCLDLT
ENDDO

where SACCOUNT is parent segment(level 1) ,SFINSUM (level 2) and SFNCLDLT(level 3) .
The segment details are already present in DBD.

Do let me know if anyone is aware of the valid syntax or any other possible approach I can follow .
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Oct 14, 2009 11:18 am
Reply with quote

it does not look like a standard IMS way of doing things...
what language, environment are You using ??
Back to top
View user's profile Send private message
nehakher

New User


Joined: 14 Oct 2009
Posts: 3
Location: mumbai

PostPosted: Wed Oct 14, 2009 11:35 am
Reply with quote

Well using a jobcard we can associate DL/I calls as well.
Correct me if I am wrong.

I have updated SBILCRPT segment at position 17 using below call(via DIRECTOR LOAD utility):
GHU SSA=SBILCRPT(KBILCRPTEQC'04291')
IOAREA POS=17,C'9'
REPL SSA=SBILCRPT

The same way if I need to insert a segment is there any possible way of doing it?
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Oct 14, 2009 11:52 am
Reply with quote

until You reply to the question I asked You will get very little help

what product are You using ???

Quote:
Well using a jobcard we can associate DL/I calls as well.

what does it mean ???
Back to top
View user's profile Send private message
nehakher

New User


Joined: 14 Oct 2009
Posts: 3
Location: mumbai

PostPosted: Wed Oct 14, 2009 11:59 am
Reply with quote

Product : Mainframes z/OS 390 version:01.10.00
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10873
Location: italy

PostPosted: Wed Oct 14, 2009 12:14 pm
Reply with quote

Quote:
Product : Mainframes z/OS 390 version:01.10.00


technically correct but completely useless information

in Your profile You define Yourself as a Software professional
You should be able to reply in a better way to question asked in order to help You
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Oct 14, 2009 7:20 pm
Reply with quote

Hello,

Mainframes z/OS 390 version:01.10.00 is not the product - it is the Operating System. . .

As Enrico mentions, you need to post much more specifically.

Who is the vendor for the "DIRECTOR LOAD utility"?

If you don't know, ask someone else who works on the system or your IMS support people. Someone knows. . .
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Wed Oct 14, 2009 10:19 pm
Reply with quote

Please pay attention to what both Enrico and Dick have told you.

And, it is NOT the standard IMS way of doing things. You are first retrieving the root segment - then you are issuing an insert without the 2nd level segment - the parent of the segment you are trying to insert. You are not properly POSITIONED - you are missing level 2 SFINSUM.

GHU SSA=SACCOUNT(KACCTNUMEQC'37429000152')
IOAREA POS=1,C' '
ISRT SSA=SFNCLDLT
ENDDO

where SACCOUNT is parent segment(level 1) ,SFINSUM (level 2) and SFNCLDLT(level 3)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> IMS DB/DC

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
No new posts Adding first / last acct numerber to ... DFSORT/ICETOOL 7
No new posts What database does Jobtrac use CA Products 4
Search our Forums:

Back to Top