How to code Page up and Page down in RPG for Single page subfile without using ROLLUP/ROLLDOWN in DSPF ?
3 18051my name is amar i want display 1st line A 2nd line M 3rd line A 4th line R in database & informatica
1 4331I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?
1 9196create or replace procedure show_tab_rec ( P_tab VARCHAR2 )
IS
cmd varchar2(50);
begin
cmd := 'select *
from '|| P_tab;
for int in ( execute immediate cmd )
loop
dbms_output.put_line ( int.ename||' '||int.deptno);
end loop;
end;
when i m compling this procedure i m getting this error
PLS-00103: Encountered the symbol "IMMEDIATE" when expecting
one
of the following:
. ( ) , * @ % & | = - + < / > at in is mod remainder not
range rem => ..
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
5 19526Hi Friends, I have a input data like, class_id Marks 101 50 101 60 101 40 102 90 102 35 And i want my output data like class_id Marks Rank 101 50 2 101 60 1 101 40 3 102 90 1 102 35 2 how to do this in datastage?
8 28667Post New HCL Interview Questions
How to delete a break in column?
What is the formula for 1 HP of a two-cycle engine?
what are all the different normalizations? : Sql dba
What is the difference between typed and untyped dataset?
What are the common ways to handle missing data in a dataset?
I am trying to include a html document in another document. Is there a way to do this?
Explain what are the different types of locators in selenium?
What are the Types of instancing properties and explain each. Explain the difference between multiuse,singleuse and globalmultiuse and which is default
Name the cics command that gives the length of twa area?
What are the advantage of c language?
Is a number php?
What is the difference between a spreadsheet and a database?
Define what are the charge carriers in p-type and n-type semiconductors?
Explain heat treatment. Why and how is it done?
How to open an older version of an object in the workspace?