Search results for query: *

We are running JD Edwards ERP 8 SP22. We run on an HPUX 11i box with UDB DB2 as the DB server. Does anyone know of any good vendors or tools that are out there for archiving and or purging? I looked at ArchTools but they do not support our configuration.

Hi, Does anyone know where I could find a list of error codes that the RUNUBE command returns. Specifically I get a return/error code of 11 and the ube fails, and I want to know what the cause of the failure is. I have a suspicion it might be related to connectivity or security but that is...

Hi, I figured out a pretty good (simple) solution. The ImportFile function return an Error Status if the column is more then the Data Source can handle. We were just not caputring this Error correctly. The ImportFile function returns the below. We were receiving -4 but not capturing it...

Hi, I have a flat file that has say 3 columns in it. These columns are tab delimited. 1234 | XYZ | ABC Now column 2 or 3 can either be null or have a valid value no more then 3 characters in length. I have set up the datastore for each of the column's data type correctly. col 1 as...

I wanted to know what peoples experiences have been that have taken J.D. Edwards training, either CNC or Developer. I have had a pretty poor experience with the training offered directly from JDE/PeopleSoft/Oracle, I wanted to know if other people have had any success with other companies that...

Easy way would be just to use a case statment: string ls_month integer i_month_num Choose Case ls_month CASE 'June' i_month_num = 06 Case 'July' i_month_num = 07 End CHOOSE

I found the answer: I should have used the below line to get the tab page name as a string. tab_control.control[i_count].classname()

Hi, I am looping through a series of tab pages on a tab control, and I need to see wether the tab pages match their control name in a string. However, I am not sure how to get the name as a sting? The variable ls_control_name is a string and I need to match it with the...

This is a tricky problem. I have one idea? There is a mouse over method that could be used depending on where you were on the screen?

Thanks for the code. I will have to analyze the code a little more. It seems to be sorting out the lowest date from the list box? I am not sure why. But thanks again.

I have the code below to populate a list box: Now I want to be able to sort the two columns in the list box when the user click on a command button which I will place on top of the columns. Any help would be appreciated. Private Sub UserForm_Activate() Dim oFSO As Object, oFolder As Object...

Hi, I would like some opinions for improving the performance of my Access database. I would like to find out some information about using start schema since the data base is going to be used for reporting purposes. If people could share some ideas or point out some resources that would be...

Hi, Actually I wanted to know if it was possible to use prompts in Free-Hand SQL, and it does seem so. I got my piece of code working now. I try not to use free hand SQL for reports but it does come in handy for testing. Thank you both for your input.

Hi, Is it possible to use @prompts while using FreeHand SQL? I seem to get an error when I try and do so. I am using a Sybase DB.

Just one thought. Context are are very useful but will cause your Universe to seem more complex. To apply context correctly requires a little more knowledge of the database and the schema involved. I would say if you have many loops while creating your Universe then you might need to...

I used the dateadd funtion of Sybase: select convert(datetime,convert(char,dateadd(day, -1, dateadd(month, 1, dateadd(day,(-datepart(day,getdate())+1), getdate() ))),101))

Hi All, We have over 60 Different Universe and I was wondering if anyone has possibly created a macro that can run through the Universes and give me a list of all the objects that are contained within them? I need this because if there are any schema changes applied to the database it becomes...

Hi, I am using Sybase. I want fro example if today is 06/04/2003 I want it to return 06/30/2003. Any help would be appreciated.

Hi, Does anyone know how to create a Business Objects object that can always return the current Month end? Any help would be apprciated. Thank you.

Looks like a data issue to me as well. I will try and check it out.