I have a stored procedure I would like to install & run with the RDK.

I assume the %RUN% record is where I would set up the command

to execute. What is the syntax or set-up required? I tried the stored

procedure name & also "run " stored procedure name. When I tried

to run RDKInstall it just breaks to the debugger.

TIA

Lisa,

Were you able to get this to work? Customizing the contents of the deployment is fairly straight-forward. Basically, modify the %RUN% to include more records using the format "/", then copy those rows into the table containing the "%RUN%" record using the key you put into the "%RUN%" record.

If you want to see the source, I believe it is RDKModuleInstall and should be in the SYSPROCS table.

Best of luck,

Cameron. Revelation

Cameron,

How do you get a sysproc routine, that is included in the install, to execute AFTER it has been loaded.

I have had to modify RDKmoduleInstall to process a EXECUTE POSTPROCEEDURES comand that 'calls' the procs at the end of its run.

If there is not something I have missed, could this be included in future upgrade.

Barry

Barry,

Take a look at RDKDeploy_Equates … it contains the supported sections:

* upgrade record sections

EQU CREATEAPP$       TO "CREATE APPLICATION"

EQU CREATEFILE$      TO "CREATE TABLES"

EQU COPYFILE$        TO "COPY TABLES"

EQU DELETEFILE$      TO "DELETE TABLES"

EQU ATTACHFILE$      TO "ATTACH TABLES"

EQU DETACHFILE$      TO "DETACH TABLES"

EQU ALIASFILE$       TO "ALIAS TABLES"

EQU COPYOSFILE$      TO "COPY OSFILE"

EQU UPDATEROW$       TO "UPDATE ROWS"

EQU DELETEROW$       TO "DELETE ROWS"

EQU EXECPROC$        TO "EXECUTE PROCEDURES"

EQU LINKPROCESS$     TO "CHAIN PROCESS"

EQU DECLAREDLL$      TO "DECLARE DLL"

So if you want to run a program called SPECIAL_UPGRADE_PROC (for simplicity, I'd suggest developing it in the SYSPROG app), all you have to do is:

UPDATE ROWS

SYSOBJ/$SPECIAL_UPGRADE_PROC

SYSREPOS/SYSPROG*STPROCEXE**SPECIAL_UPGRADE_PROC



EXECUTE PROCEDURES

SPECIAL_UPGRADE_PROC



DELETE ROWS

SYSOBJ/$SPECIAL_UPGRADE_PROC

SYSREPOS/SYSPROG*STPROCEXE**SPECIAL_UPGRADE_PROC

Cameron. Revelation

Cam.

Thanks for that, never though of using the options that way, even though I think my way is less fiddly.

BUT

1)

Looking at the RDKInstalmodule code again I cant see where UPDATEROWS$ is processed, have I missed something in an upgrade.

I am on Ver 3.5.1.

2)

Also, Why cant COPYFILE$ copy the DICT. table as a way of distributing dict tables on client systems. I have changed mine to do so.

3)

I can't make a 'Full System' deployment, I get the following message with a break to debugger:

RUNTIME ERROR

ENG0010. REPOS.DOSGEN..CHECKOUT, Line 1. Variable has not been assigned a value.

4)

I cant get the Application Manager window to disappear using:

• Hide Engine

Foo=ShowWindow(GetEngineWindow(),0)

• Hide AppManager

Foo= set_property("SYSTEM","VISIBLE",1)

Foo= set_property("SYSTEM","VISIBLE",0)

Hope you can provide some insight into these problems.

regards

Barry

Barry,

3) I can't make a 'Full System' deployment, I get the following message with a break to debugger: ENG0010. REPOS.DOSGEN..CHECKOUT, Line 1. Variable has not been assigned a value.

That has been corrected in 3.5p2.

4) I cant get the Application Manager window to disappear

A resolution for this issue is planned for the 3.5 release.

Cameron. Revelation

View this thread on the forum...