RH909

[hsiao_te_wang]

Hi Lists,
I just installed the Xe stand alone version on my laptop. However, the cross reference facility (RH909) did not work. Even after I rebuilded the relationships for all objects, I still get no information when I want to know functions like tables used by programs, etc.
I was told the RH909 will not work on stand alone. Is this true or anything else I have to do to get the objects relationships ?
Appreciate any comments !
John

 

[CHo]

That is

C Ho
Intermediate Programmer/Analyst
Xe SP 15.1 AS/400 V4R3 coexistant
CO on SQL 7.0

 

[jdelist89]

That's quite reasonable, -
Xref tables take about 5-7Gb on Xe. (Oracle, MS
SQL. I don't think Access will take significantly less)
Limit for Access database is 1Gb for '97 version and 2Gb for '2000 .

===8<==============Original message text===============
Hi Lists,
I just installed the Xe stand alone version on my laptop. However, the cross reference facility (RH909) did not work. Even after I rebuilded the relationships for all objects, I still get no information when I want to know functions like tables used by programs, etc.
I was told the RH909 will not work on stand alone. Is this

 

[jdelist89]

Hello again hsiao_te_wang,

I thought a little bit, and got some ideas which can help you if need
Xref on standalone VERY much.

1) Install full package from server installation of OneWorld.
2) Rename \B7\PD7333 (or whatever path code you used) into \B7\DEMO
3) Copy jde.ini from 'real Standalone' into \WINNT (or ...).
4) Copy Debby from 'real Standalone' into \B7\DEMO\data
5) Check 'OneWorld Local' ODBC datasource exist.
6) Most enormous step -
Install MS-SQL server locally (or Personal Oracle 8, - it's free, IMHO)
7) Copy Xref tables (there are 2 of them, check names in docs) from
your server database into local MS-SQL/Oracle
8) Make ODBC data source (MS-SQL) or NET8 settings (Oracle) which
refers to new database.
9) Make New datasource in JDE, wich points to Datasource mentioned in (8).
10) Make OCM mappings for 2 Xref tables pointing to new datasource.

Generally, looks to be enough.

P.S. Performance, Cost of license, space requirements, availability of
'Big' JDE, etc. - that's your problems

P.P.S. Backing to topic about copying data from CRP to standalone . -
It's possible to transfer all Standalone database into MS-SQL
or Oracle, and, in theory it will work.
By this we eliminate 2Gb Access Limit and get working standalone without
splitting database.


===8<==============Original message text===============
Hi Lists,
I just installed the Xe stand alone version on my laptop. However, the cross reference facility (RH909) did not work. Even after I rebuilded the relationships for all objects, I still get no information when I want to know functions like tables used by programs, etc.
I was told the RH909 will not work on stand alone. Is this