Hi All,

I need to add an employee role in all of our 100 companies. Right now i have to add role in each company one by one. Is there any other way to add the same in all company simultaneously so that my time and work can minimize.

Viplov

Hi viplov,

This is a work around. It would work if you have the same project / reference Model, Version , Role and Employee for all the companies. Define the role for one company. take the sequential dump of the table ttaad4226m000. Delete the records for all the other employee's in the text file. Create Table from this sequential dump ttaad4227m000 using "Append if table exists" for the other 99 companies.

Rita's idea will work and to make it faster intead of doing manually for 99 companies -
Create Table from this sequential dump ttaad4227m000 using "Append if table exists" for the other 99 companies.
You can use the bdbpost will the following option -
-C : Range of company numbers for which bdbpost will be done (ex:000-100)
You can also make a shell script/batch files and run a bdbpost for each company in background mode to run in parallel.

Can you please provide me the syntax of bdbpost..

Thanks in advance

Viplov

Hi Viplov

You have to take dump of following tables tgbrg110, tgbrg820 & tgbrg840 then remove unwanted records from dump (don't delete first two lines) and then execute following syntax :

bdbpost6.1 -Rmnf -t"|" -D . -E <err file name> -c <desired company>

you can save above syntax in a file and execute at os level i.e.

bdbpost6.1 -Rmnf -t"|" -D . -E <err file name> -c 991
bdbpost6.1 -Rmnf -t"|" -D . -E <err file name> -c 992
bdbpost6.1 -Rmnf -t"|" -D . -E <err file name> -c 995
...
...
...

Hope this will works

rgds
Sanjay

Hi, Sanjay :)

I did exactly what you said, and it is pleasure to say that it works and works perfectly....but the bdbpost command works only in bsp login.

Thanks a lot


Viplov

Pls check .profile of bsp and desired login if your OS is unix.

rgds
Sanjay

Dear Sanjay

I have seen and changed the required profile kindly let me know the detail of bdbpost syntax if possible kindly provide all switches for the same.


Viplov

The options that can be used with this executable are :

-A Append rows (skip and show total duplicates) or Create new table
-I <file> Redirects input from input-file <file>
-O <file> Redirects output to output-file <file>
-E <file> Redirects errors to error-file <file>
-R Append rows (replace & show total duplicates) or Create new table
-f Fast mode (first rows, then indexes)
-K/-k Backup/Drop existing table
-l Display contents of input
-e File to store unsuccessfully 'posted' tables
-d Database Driver type
B(isam) (b)T(am) O(racle) I(nformix)
S(ybase) D(B2) M(SQL-Server)
<host> Remote system (name is <host>)
<driver>[<spec>] - driver name [ specification ]
Options -x, -t and -D described below are required while
uploading ASCII files from other database to bshell format
-x To load fix length ASCII file (.F) from other database
-t Separator
Needed while loading an ASCII file (.S) from other database
-m Disable domain constraints
-n Ignore referential integrity constraints
-D Directory name for ASCII files to be uploaded
-c Tables will be created with specified company number
-C Range of company numbers (ex:000-100)
-I Ignore domain range error and skip record
-p <pack_comb>: Define package combination
<pattern> Pattern to specify tables (wildcards allowed)
-q <output-file>: Redirect terminal output to output-file
-u Short usage
-U Usage
-V/-v Version information

rgds
Sanjay

Hi Sanjay,


Thanks for the list. This adds to my knowledgebase.

Dear All
how to condition set on particuler workcenter
Please help me

Thanks
Gurmeet

What kind of condition set would you like to apply...