Search results for query: *

Hi Experts, I am familiar with SAP BW. I have heard that some companies use SAP BW and have report net of Cognos. My question is: If your company has already SAP R/3 and SAP BW , why should you buy/use something as Cognos report Net.? So in other words what benifits do you gain? Or are there...

I am familiar with SAP BW. I have heard that some companies use SAP BW and have report net of Cognos. My question is: If your company has already SAP R/3 and SAP BW , why should you buy/use something as Cognos report Net.? So in other words what benifits do you gain? Or are there not any...

Thanks for your tips, its now working well

Hi experts, Whilst trying to run a Cognos Impromptu report we are encounterering a Query Server Error. DMS-GENERAL, A general exception has occurred during operation 'asynchronous open' What does this error means ?? and how to resolve it ? Kindly help

Thanks Dave Griffin D Das

Hi Experts, I have two tables one "Sales Table - SALES_TABLE01" and another "Inventory Table - INVENTORY_TABLE02" now I want to merge two tables, Logic is to add sales & margin item-wise & month-wise and extract last transaction itemwise & month-wise from Inventory table...

Hi, Can you also tell me where did you get AS service pak 3. Can you please give me the full URL. I am a new user. Can you tell me is it possible to do left/outer etc joins on MSOLAP. If yes, please tell me how ?

HI Experts, How you do left/right joins etc on MSOLAP Thks in advance

Hi Experts, I am a new user on MSOLAP . I want to know how you do joins as left/outer, right, cross etc. Thks in advance

Thanks to all, it was a silly mistake. The mistake was on call statement 'T1' program was written in lower case. Thanks once again for your kind reply Debabrata das

I am sorry to give single quotes, pl include that. I think I am doing mistake while compilation as I have not included T1 program while CRTSQLRPGI or any other mistake ... Pl point me out ...

I have one CL program named : T1 and another on SQLRPGLE : S1 and I am calling T1 program from S1 sample program C CALL T1 C ....... C/EXEC SQL C DELETE ..... C/END-SQL C SETON LR I have compiled T1 with option 14 and seperatly it is running and I have...

Even though I put decimals on FORMAT. It is still showing zeros. Can you please check at your end with Ms-Access DB for small sample of data where one field data type is numeric, precision 18 and scale: 3 and let me know... Thks in advance

Thanks dear for yr kind suggestions, it worked

Yes, I can compile it, if I give DSPLY statement before and after SQL it displays on the screen, but not executing SQL statement

If it is there then WHY it is not executing ??? even simple SQLRPGLE IS NOT EXECUTING Sample Program C/exec sql C+ INSERT INTO dastest/item C+ select mmcono,mmitno C+ from mitmas C/end-exec C...

Hi Experts, Can any one tell me how can i pass predefined parameters as "from date" to "to date" for a particular DB having such parameters for extracting sales report for a particular month. It would be help if any one can give me solutions thru Decision Stream for...

Boss, my database is on Ms-Access, if I change the field size from "decimal" to "float" then it shows figure on PP but for decimal it shows all zeros. I have checked through MS-Access query the figures are showing correct. for decimal precision is : 15 and scale is :6...

Can you please name the SQL licensed program I am listing you what we have. Please point me out Program Status Description 5798RZG *INSTALLED AS/400 Service Agent 5722XW1 *COMPATIBLE Client Access Enablement Support 5722XW1 *COMPATIBLE Client Access Family for Windows 5722XE1 *COMPATIBLE...

Older one is 170 & new one is iseries 270. While doing DSPLICPGM on both servers on 170 5769RG1 *COMPATIBLE ILE RPG for AS/400 on iseries 270 5722WDS *COMPATIBLE Compiler - ILE RPG IV I cannot find "ILE RPG for AS/400" on iseries 270 is it because of that ????