Recent content by sudipta

Thanks a lot. I think to change it permanently I need to modify startup.pf file.

Thanks a lot. Yes in UAT it's mdy and in production it's dmy. Please tell me how to change it to mdy in prod.

Hi, In my UAT database in tab1 i have a date column in mm/dd/yyyy format. I am able to load dfile for that table. But in my production in same table in same field in same format I am not able to the the same d file. I am getting the below error. >> ERROR READING LINE #1 (Offset=0): ** The...

But I did not set any authentication. I am using windows authenticationonly. Plz upadate me. what i can do

yes table owner is pub, but i am getting the below error when doing any dml opration on "SAPMCTax" table. === SQL Exception 1 === SQLState=HY000 ErrorCode=-20228 [JDBC Progress Driver]:Access denied(Authorisation failed) (7512) I have 2 tables 1. In 1st the newly created table owned by pub...

Hi, I am new to Progress. I am trying to execute the following statements from SQL Explorer: set schema 'arijit'; select * from arijit.ReceiptHeads; delete from arijit.ReceiptHeads; The output is as follows: === Statement 1. === set schema 'arijit'; === Statement 2. === select * from...

Hi, I am new to Progress. I am trying to execute the following statements from SQL Explorer: set schema 'arijit'; select * from arijit.ReceiptHeads; delete from arijit.ReceiptHeads; The output is as follows: === Statement 1. === set schema 'arijit'; === Statement 2. === select *...

Hi, I am new to Progress. I am trying to execute the following statements from SQL Explorer: set schema 'arijit'; select * from arijit.ReceiptHeads; delete from arijit.ReceiptHeads; The output is as follows: === Statement 1. === set schema 'arijit'; === Statement 2. === select *...

Hi, I am new to Progress DB. I am using Progress9.1 D on Windows XP environment. Some of our databases are started using proserve command. I am unable to find the port database is started. Please someone help.

Hi, I am new to SQL-92 \ 4GL.. I want to describe table using SQL-92 \ 4GL , as in Oracle... Can any one help me...

Hi Tom, While running mpro for 1 st time I am getting below error C:\Program Files\PROGRESS\src>mpro -db C:\Rem\db\pos.db -p loaddf.p>load_df.txt Error: Files\PROGRESS\bin\icu\data\\""=="" was unexpected at this time. Second time if I run the same mpro command error is not coming...

Thanks tom, I have tested it successfully in uat, My test scenario is below. 1. Created one table 2. Dump the table 3. Drop the table 4. Import the table using mpro. It's imported. I will test the same in my live env with the live db. I will take your help if any error found. Thanks

We are using Progress 9.1D on Windows XP environment. The paths included in the load_df contains forward slash ( as for Linux / Unix environment). Shall we modify that path... Else below error message are encountered.. ** "prodict/user/uservar.i" was not found. (293) ** C:\Program...

Thanks Tom. I have added the following code in the file load_df.p: DEFINE BUFFER file1 FOR remdb._File. DEFINE BUFFER field1 FOR remdb._Field. The above error got corrected A new error is encountered now. It is as follows: ** "prodict/dump/_lodv5df.p" was not found. (293) I am breifing...

Hi All, I am new to this community. I am trying to load df file wiithout using GUI. I did the following steps. 1) Run the command extractpl prodict.pl 2) Run the command extractpl adecomm.pl 3) It created the prodict and adecomm folder. 4. My db name is remdb.I made changes in load_df...