Hi All,   Is there a way to extract a column from Oracle that contains the number 2005101000000000716 into a character resulting column?   I will be using the Query Builder Task in EG 4.3 (M3) with SAS/ACCESS to Oracle on a Windows 7 Platform.   Something like a "to_char" Oracle function used in a SQL Passthrough ..... Thanks ... View more

Hi All,   After exporting my EG project in order to run it in batch mode, I got the problem below: When I look at my exported code, whenever there was a query builder, it does not put the original code there but, refers to the EG project rather. Like in the example below. I was expecting it to export the code for query builders as well...   Any help to clarify this would be much appreciated,   Thanks   /*   START OF NODE: Query for MTH_CUST_IDV_CURR   */ %_eg_hidenotesandsource; %LET _CLIENTTASKLABEL='Query for MTH_CUST_IDV_CURR'; %LET _CLIENTPROJECTPATH= '/home/lsimon02/SAND_BOX/BHPB_DEV/CRM/original_BHPB_projects/1. CRM_MODEL_V5.egp'; %LET _CLIENTPROJECTNAME='1. CRM_MODEL_V5.egp'; ... View more

Hi All, Is there a way a can save a copy of my program's execution log outside of the EG Project? I cannot re-route my session's log. I need the log to remain intact in the EG session. This would be equivalent to "Exporting" the log using point-and-click from the menu. Thank you, LS ... View more

Hi, I am running EG on AIX. From within a "Program" in EG I can run UNIX commands such as x 'mkdir xxxx' , x "\rm file.txt' , etc.. Is there a way to run a .ksh script the same way I run the commands above? Thank you ... View more

Hi Guys, I am looking for code example and tips on how to invoke a DB2 stored process where I pass parameters and the procedure sends back parameters to my EG session. Thank you all for your help ... View more

Hi, Is there a way to drop columns from the output table when I am using the Query Builder in EG? Thank you ... View more

Hi, I am running EM 5.3, Java Web deployed to a Solaris 10 box. Most of the time, the GUI does not get refreshed and the hour-glass icon stays on the screen although the process has finished executing (a decision tree for example ...). I tried a lot of things already, including increasing the Java parameters that go in the AP server config. My Java version on both Client and Server seems to be OK and is 1.4.2_09. Has anybody experienced this situation of has a tip? Thank you all ... View more