Search results for query: *

Can someone tell me how do I delete some rows effectively on a daily basis and update it with new rows from a temporary sql table. I have a huge table of 120 Mil rows(actualtable). and I need to update it with 1mil rows(temptable) everyday. I usually do this but it takes awful lot of time and...

rasanders , thanks for the reply, database: MSSQL server 2k the data we have is from 200212 till date. All I need is to come up with some idea which could improve my data-loading procedure for every month(abt 3mil rows). which takes the data from a table(45 mil rows)and inserts into another...

Can any one help with some database issues. I have to deal with huge tables like tableA (70 mil rows )and TableB(45 mil rows.) and they grow on timely basis. Every month I have to insert from TableB into Table A with some calculations. On an avg. a month's data is around 5 Mil. The way Im doing...

Thanks guys! -P

How can I display a message to user saying "there are no are no records at this time" when there are 0 Records from the table, something like following statement? IF RECORDCOUNT EQ 0 THEN TYPE "No records at this time"; Thanks -P

Can some one help me with the below If statement, I dont know where I'm going wrong, it looks simple but, wont work. DEFINE FILE MYFILE TEMP/D12.2=IF FIELD1='A' AND FIELD2='B' AND FIELD3='ASD' THEN MYFIELD ELSE 0; END TABLE FILE MYFILE PRINT TEMP END gives me below error message 0 ERROR AT OR...

can anyone tell me how to verify if table exists before I issue DROP TABLE JOBS for the following statement SET SQLENGINE=SQLMSS SQL SQLMSS SET SERVER CONN1 SET COMMIT = ON SQL SQLMSS BEGIN TRANSACTION DROP TABLE JOBS COMMIT WORK ; END by the way, im getting this error message when I try...

Can anyone help me with IFrames. Im using an IFrame having a SRC for another page(html with some javascripts inside) on another server. I couldn't find out the resolution for that problem on the web. It gives me an "Access Denied" message. I know its got to do something with security but i dont...

Hi Eva, Im not using 5.23 actually I still have 4.36, what I meant to say was I was trying to install the new version but it dint let me so I reverted back to 4.36, may be that caused the reporting server not to run reports through browser. anyway if you can think of something let me know thanks -P

I dont have any system administrator here. The thing is it used to work fine when i run reports through browser until i tried to install new version 5.23 then i had to uninstall that again. I can still run/view the reports through desktop viewer. And the page is passing values to cgi engine. but...

I am getting a warning message on the browser when i run a html file(http://mywebserver/approot/cmisreports/file.htm) after i publish any FEX Procedure. Im using WF436 and the message is: Your connection to server has been lost, please reconnect. The URL where the page stops is...

The new version will be on a different server, although I tried installing it on the same box but never worked. I have successfully installed 5.3.2 on a separate machine but all my apps are in 4.3.6 and I want to upgrade all of them. Do we have re-write all masters/fex's?

Can anyone tell me if there is any easy process to move my apps from 4.3.6 to 5.2.3? I tried to copy and paste it never worked though -P

Thanks guys, i got it working by SET ALL=PASS where matchedfield is missing -P

I know the missing names are blank but I want to print out only those missing or unmatched fields, I tried set ALL=PASS but it dint work. Im using WF436 Please help me in printing unmatched fields after an join(outer) -P

JOIN EUSER.EUSERNAME IN eUser TO ALL EATTRIBU.EUSERNAME IN eAttribute AS JOIN0 SET ALL = ON TABLE FILE EUSER PRINT EUSERNAME EUPDATEDTIME EDISTINGUISHEDNAME WHERE EATTRIBUTE.EUSERNAME EQ '.'; I am trying to display unmatched fields after a join, but it comes up with no results...

how do i display a field after a join from specific table. JOIN EUSER.EUSERNAME IN eUser TO ALL EATTRIBU.EUSERNAME IN eAttribute AS JOIN0 SET ALL =ON TABLE FILE EUSER i wanna print the join fields from both the tables euser.eusername eattribute.eusername? END

Gizzy17, Just to give you an idea of what I did so far. IN MY DATABASE: SELECT count(*) FROM eUser LEFT OUTER JOIN eAttribute ON eUser.eUserName = eAttribute.eUserName...gives me a count (103) SELECT count(*) FROM eUser right OUTER JOIN eAttribute ON eUser.eUserName =...

Outer join is not working evenwhen i say SET ALL=ON, it just gives me the same records as if an inner join. I checked the record count/records affected on my sql database for the outerjoin and it is different. im using webfocus 4.3.6 is it SET ALL=ON or -SET ALL=ON ? I tried both anyway and...

lower case 's' works !!!!! Thanks a lot gizzy