Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Error while inserting segment in existing IMS database

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
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    Post subject: Error while inserting segment in existing IMS database
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Wed Oct 14, 2009 11:18 am    Post subject: Reply to: Error while inserting segment in existing IMS data
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    Post subject: Reply to: Error while inserting segment in existing IMS data
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

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Wed Oct 14, 2009 11:52 am    Post subject: Reply to: Error while inserting segment in existing IMS data
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    Post subject: Reply to: Error while inserting segment in existing IMS data
Reply with quote

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

Global Moderator


Joined: 14 Mar 2007
Posts: 10211
Location: italy

PostPosted: Wed Oct 14, 2009 12:14 pm    Post subject: Reply to: Error while inserting segment in existing IMS data
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

Site Director


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

PostPosted: Wed Oct 14, 2009 7:20 pm    Post subject:
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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> IMS DB/DC All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm
No new posts IMS Database backup info ashek15 IMS DB/DC 14 Wed Nov 16, 2016 5:29 am
No new posts Error during restore rename archanamuthukrishnan All Other Mainframe Topics 2 Fri Oct 14, 2016 3:30 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us