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: 10256
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: 10256
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: 10256
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 Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm
No new posts INVOKE WEBSERVICE error danik56 CICS 11 Thu Mar 09, 2017 11:52 am


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