Recent content by StuartT

It has been a while since i did any dictionary loads, but i thought that to do a load throught the dictionary that the .d file had to have the same amount of entries as there are fields in the table. Anyway, the best way to handle this (I am assuming you have a fairly recent version of...

Why are you bothering with a server process at all if you are only running the load and are not allowing any client logins. In the past I have always performed loads of any type in single user mode when at all possible

works fine for me on version 10.2B

Treat them in the way we had to in the olden days of 5, that is with some of them you have to repeatedly close then open with append. e.g Output stream s1 to <File> .. .. put stream s1 <sehsdhfsdljfhsdf> skip. output stream s1 close. .. .. Output stream s1 to <File> append. put stream s1...

Did you not even bother to read the 1st reply to your problem where i gave you the answer an hour and a half ago (as fas as I know both ux2dos and unix2dos should exist if not try both as they work in the same manner)

It sounds very much to me that you are producing the file under a UNIX/linux environment then reading in windows. Unix and windows handle carriage returns differently and Wordpad being a more modern editor than notepad can handle this whereas notepad cannot. The only way to avoid this is to...

if you add " 2> <ERRORLOG> to the end of your command line you will get a separate error log. In unix > is to direct output that would be on screen to a file >> is to direct output that would be on screen to a file but to append to an existing file 2> means "direct error output" and 2>> means...

You should be ok as long as you haven't accidentally utilised any of the new 10.2b features.

Hi alif, When you select dump, you are given the oprion of dumping data either for a specific table or for all tables. If you select all, you will get a separate dump file for each table a progress dump file has a filename ending in .d within the dictionary, there is also an option to view schemas

Users should NEVER end up with very long open transactions, it sounds as if your system is very poorly scoped and could result in the loss of much work should the users log off abnormally. The worse case scenario would be the transaction scoped to the login script whereby should the user session...

kill -15 is usually the safe way to go as this will shut the processes down as cleanly as possible, if you do it on a server process then check the log file you will see that it initiates a PROSHUT

When migrating to a new system, the usual process is for the vendor to provide you with a breakdown of what data they require and in what format they require it. You then would have to have a good working knowledge of the current system and code data extract routines to interrogate the DB and...

I have difinitely used unix2dos from within an os-command in the past, cant try it out now as I dont have a unix environment

What he means by rough is a very simple screen with no fancy frills to try out your code.

The easiest way is to have a temp table containing fields relating to all of the columns in the main spreadsheet and the column required from the second. you then read from the main file and create a temp table record for each row of the spreadsheet. You then close the file and read from the...