Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 25th February 2002, 13:44
i96nds's Avatar
i96nds i96nds is offline
Member
 
Join Date: Dec 2001
Location: Bucharest, Romania
Posts: 87
i96nds is on a distinguished road
Baan: Baan IV c4 - DB: Oracle 9i, MS SQL 2000 - OS: 2003 and AIX5L
Tools Tables which can be created for a company different than 000

Hi,

I wonder if anybody can help me with this:
I am trying to write a script which generates the name of the tables that are Valid for a certain Package Combination. This would be useful for me to get a file that contains the list of the tables - for bdbpre6.1. In this script I have added an option if I want to include the logical tables, etc.

The ideea is quite nice and useful. The script works fine. I get the list of the tables. There is a problem regarding TOOLS tables. If I use session "Create seq dump of table" - ttaad4226m000, only the following tables are dumped, if I dump a company <> 000.

ttaad500
ttaad501
ttaad503
ttaad505
ttaad506
ttaad507
ttaad510
ttaad511
ttaad512
tttxt001
tttxt002
tttxt003
tttxt004
tttxt005
tttxt006
tttxt007
tttxt008
tttxt010
tttxt012
tttxt016
tttxt030

If we dump company 000, all TOOLS tables are dumped. So, only few "tt" tables can be created in a company <> 000. Do you have any idea how does Baan know the list of this tables? I did not find anything useful in table ttadv420.... There must be a field YES/NO which tells that a table, for example tttxt020 or ttdsk* can be created only in company 000.

Does anybody have any idea?
__________________
Stefan Ninu
-------------------------
P.S. By sending this message NO TREE had to die, NO PAPER was wasted and THE AIR was not polluted!!!
...only a few electrons where temporarely inconvenienced in the process!
Reply With Quote
  #2  
Old 26th February 2002, 16:03
alejandro's Avatar
alejandro alejandro is offline
Senior Member
 
Join Date: Feb 2002
Location: Madrid - Spain
Posts: 144
alejandro is on a distinguished road
Baan: IV c4 - DB: Oracle 8 - OS: Unix
Maybe...

There is a function that returns you if a table is present in a certain company.(BaaN IV c4)

If I understood you well, this I propose is an indirect method but, maybe...

#pragma used dll ottadvtablecomp

long yeno
yeno=table.in.compnr(string table(8),long cmp )

Hope this help...
Reply With Quote
  #3  
Old 6th March 2002, 10:13
i96nds's Avatar
i96nds i96nds is offline
Member
 
Join Date: Dec 2001
Location: Bucharest, Romania
Posts: 87
i96nds is on a distinguished road
Baan: Baan IV c4 - DB: Oracle 9i, MS SQL 2000 - OS: 2003 and AIX5L
Question Package combinations

Thanks, this solves only a part of the problem. What I really need to do is to generate a list of tables for a specific package combination. This is necessary because we have several companies, in a multi-company scenario. So, I need to make a dump of all these companies at the same time. If I dump 4 companies that reside on the same package combination, I should use only one list of tables, and not four, depending on the output of table.in.compnr(...). I will keep hins functon in mind, though. Thanks.

I managed to find this function in ttstpsearchvrc:

function extern long vrc_search_table
(domain ttadv.cpac cpac,
domain ttadv.cmod cmod,
domain ttadv.flno flno,
long tdep
ref domain ttadv.vers tver,
ref domain ttadv.rele trel,
ref domain ttadv.cust tcus,
)

I thought I may use this function, since this is what I need to get the right list of tables. But I do not understand what the parameter tdep does... Any clue?

Anyway, I still have the question about how does this function know that some Tools tables should not exist in any company diferent than 000....

Any idea?
Thanks,
__________________
Stefan Ninu
-------------------------
P.S. By sending this message NO TREE had to die, NO PAPER was wasted and THE AIR was not polluted!!!
...only a few electrons where temporarely inconvenienced in the process!
Reply With Quote
  #4  
Old 6th March 2002, 15:10
alejandro's Avatar
alejandro alejandro is offline
Senior Member
 
Join Date: Feb 2002
Location: Madrid - Spain
Posts: 144
alejandro is on a distinguished road
Baan: IV c4 - DB: Oracle 8 - OS: Unix
And this?

Well,

Session ttaad4222m000 makes a report counting rows in a table.
If you entry:

- Company: The first company number in a package combination
- Package : From tt
To tt
- Table : From [empty]
To zzz999

Then in the report you have the list of tables defined in that package combination, for that package.

You can put the output to a file and read it.
Notice that the first table is always in the same row of the file, and you have to read after line read (without trailing spaces begin with Total)

You can define a Job.
As you can see this tables are in the standard package tt, and tt do not belong to any package combination than standard (ttaad1121m000) So tools tables are those you listed in any package combination. ( I guess you forgot in that list table ttaad502).

I have no other idea hopefull for you.
Hope this helps.

Last edited by alejandro : 6th March 2002 at 15:12.
Reply With Quote
  #5  
Old 6th March 2002, 20:11
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,032
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Hi Stephen,

I guess you are referring to this dll -

ttdllvrcsearch

I could not find the

ttstpsearchvrc
Reply With Quote
  #6  
Old 6th March 2002, 21:06
i96nds's Avatar
i96nds i96nds is offline
Member
 
Join Date: Dec 2001
Location: Bucharest, Romania
Posts: 87
i96nds is on a distinguished road
Baan: Baan IV c4 - DB: Oracle 9i, MS SQL 2000 - OS: 2003 and AIX5L
I'm only human...

I tested so many things that I was dizzy. I have written the wrong dll, you are right.

It should have been: ttdllvrcsearch

$ >bic_info6.1 -e ottdllvrcsearch

---------------------------DLL PROTOTYPES-------------------------------

............................. - many others - .....................

function extern long vrc_search_table(
domain ttadv.cpac cpac,
domain ttadv.cmod cmod,
domain ttadv.flno flno,
long tdep,
ref domain ttadv.vers tver() fixed,
ref domain ttadv.rele trel() fixed,
ref domain ttadv.cust tcus() fixed )
__________________
Stefan Ninu
-------------------------
P.S. By sending this message NO TREE had to die, NO PAPER was wasted and THE AIR was not polluted!!!
...only a few electrons where temporarely inconvenienced in the process!
Reply With Quote
Sponsored Links
  #7  
Old 6th March 2002, 21:08
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,032
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Sure thats ok... you seem to be working late in Romania...

did you try to use the session to get the documentation

ttstpbaandoc (in HTML form)

ttstpobjinfo (show object info - gives output on the display browser) instead of using the command line options...
Reply With Quote
  #8  
Old 6th March 2002, 21:23
i96nds's Avatar
i96nds i96nds is offline
Member
 
Join Date: Dec 2001
Location: Bucharest, Romania
Posts: 87
i96nds is on a distinguished road
Baan: Baan IV c4 - DB: Oracle 9i, MS SQL 2000 - OS: 2003 and AIX5L
Yes, it is quite late...

Hi,

I think it is daylight in USA, right? In fact, I work in Italy now, for a while, as you can see from the e-mail address. Here I have one extra hour, comparing with Bucharest.

A real Baan "addict" can not sleep until he finds out the answer to his questions... I am at home, connected to the IBM Shared Network, in fact...

I did not understand what you ment with:
ttstpbaandoc (in HTML form). How can I get this? Please guide me, if possible.

The baan session I think it is ttstpsessinfo. It gives quite the same output, right? Or... can I get extra information if I use the Baan session?

Ciao,
__________________
Stefan Ninu
-------------------------
P.S. By sending this message NO TREE had to die, NO PAPER was wasted and THE AIR was not polluted!!!
...only a few electrons where temporarely inconvenienced in the process!
Reply With Quote
  #9  
Old 6th March 2002, 21:33
NPRao's Avatar
NPRao NPRao is offline
Guru
 
Join Date: Aug 2001
Location: Pacific NW, USA
Posts: 3,032
NPRao will become famous soon enough
Baan: iBaanERP-5.2a(Reger),SSA-ERP-LN-6.1,Infor LN-10.x - DB: Oracle-10g,11g,12c,MS-SQL - OS: HP-UX, Linux, Windows
Yes its day light here.

the session ttstpbaandoc - is "Generate Library Documentation" you can get the library function prototypes etc in a HTML pages, can be viewed with Internet Explorer. If you cant find it in the tools menus, use the start, run option to check up if its delivered to you or not.

I dont know which BaaN version are you working on. But this is available in the New ERP series.

the session, ttstpobjinfo (show object info - gives output on the display browser) instead of using the command line options...
$ >bic_info6.1 -e ottdllvrcsearch
I feel that all the command line options of the bic_info are built into tihs sesion, ttstpobjinfo.

I hope this helps you out.

Good Luck!
Reply With Quote
  #10  
Old 6th March 2002, 22:17
i96nds's Avatar
i96nds i96nds is offline
Member
 
Join Date: Dec 2001
Location: Bucharest, Romania
Posts: 87
i96nds is on a distinguished road
Baan: Baan IV c4 - DB: Oracle 9i, MS SQL 2000 - OS: 2003 and AIX5L
Ciao,

Unfortunately I do not have any Baan ERP accesible here....
I work on Baan IV c4. Now I do understand why I could not find the sessions

ttstpobjinfo
ttstpbaandoc

Thank you anyway. I hope that one day I will be able to understand all secrets of the tools sessions, which seem very interesting to me, because of the skills a programmer should have to write such sessions. I will keep learning... But the documentation that Baan offers is quite poor, I may say.

Regards,
__________________
Stefan Ninu
-------------------------
P.S. By sending this message NO TREE had to die, NO PAPER was wasted and THE AIR was not polluted!!!
...only a few electrons where temporarely inconvenienced in the process!
Reply With Quote
  #11  
Old 12th March 2002, 11:03
i96nds's Avatar
i96nds i96nds is offline
Member
 
Join Date: Dec 2001
Location: Bucharest, Romania
Posts: 87
i96nds is on a distinguished road
Baan: Baan IV c4 - DB: Oracle 9i, MS SQL 2000 - OS: 2003 and AIX5L
Patches and Tools Tables...

I noticed something strange in what "alejandro" said. He told me that I have forgotten table ttaad502. I had taken a look in my system few days ago and I did NOT have this table. I knew some tables were delivered by baan at a certain moment. I managed to find on Baan support the solution 104950:

Quote:
After this action you should create 3 new tables for company 000. The easiest way is to start general table maintanance and select this table. On the question "File does not exist, allocate" you should answer "Yes" and the table will be created. Do this action for the tables ttaad321 ttaad502 and ttaad330. Table ttaad502 should be created for all companies.
I found out that there are some other tools tables delivered wi SP9 for BaanIVc4: ttaad322, ttaad331, ttaad508.

I did some new researches and.... I have table ttaad502 now. Surprise!!! Patches were installed last night !

Anyway, be careful with the patches.

The strange thing that I noticed is that I was able to allocate the table ttadv200 (Sessions !!!) in company 110, using General Table Maintainance , which seems quite strange to me.

All Tools tables, except the ones written above in previous posts + ttaad502, can NEVER be created using the session "Create tables", but can be created using GTM.

The session "Create tables" is smart enough not to create tables ttaad321, ttaad330 in company 110. It only creates table ttaad502, as described in the solution I quoted here.

Here I come again:
How does session "Create tables" know to do this? Why GTM and "Create tables" do not use the same algorithm / function for checking the validity of a table for a certain company (diferent than 000) ? It seems that they are not both using "ttdllvrcsearch"...

I am quite confused, now. The table ttadv200 can NOT be deleted using session "Delete tables". So, I think this is a bug, since this table can be created using GTM but can never be deleted. What do you think?

Regards,
__________________
Stefan Ninu
-------------------------
P.S. By sending this message NO TREE had to die, NO PAPER was wasted and THE AIR was not polluted!!!
...only a few electrons where temporarely inconvenienced in the process!

Last edited by i96nds : 12th March 2002 at 11:41.
Reply With Quote
  #12  
Old 13th March 2002, 02:07
alejandro's Avatar
alejandro alejandro is offline
Senior Member
 
Join Date: Feb 2002
Location: Madrid - Spain
Posts: 144
alejandro is on a distinguished road
Baan: IV c4 - DB: Oracle 8 - OS: Unix
I think is a bug too

Your explanation seems to be very clear. It is inconsistent. I think you should report this like a BaaN to support.

Be luck. Sorry, because I have no other thikg to suggest you.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Issues with mimic of database auths. sessions BaanTech Tools Administration & Installation 3 6th February 2017 08:40
Creating tables in company 000 pjohns Tools Administration & Installation 10 14th November 2002 18:31
Segregating tools company 000 vanwinkle Operating Systems & Databases 7 5th February 2002 15:22


All times are GMT +2. The time now is 13:43.


©2001-2017 - Baanboard.com - Baanforums.com