pears.NetFileList [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.NetFileList ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create procedure "pears"."NetFileList"( in "pWebUserID" char(20),in "pFileType" char(25) ) 
result( "FileType" char(25),"FilePath" char(250),"FileDate" date,"FileDescription" char(100) ) 
begin
  // Dummy place holder function
  // Live version will use pWebUserID to look up payroll company id and payroll employee code and then call Accord.Accordpayrollruns
  declare local temporary table "Xs"(
    "tp" char(25) null,
    "pth" char(250) null,
    "dt" date null,
    "descrip" char(100) null,) not transactional;insert into "Xs"( "tp","pth","dt","descrip" ) values( 'A','c:\\iqx\\pdfs\\payslip\\payslip1.pdf','2012-1-6','Payslip w/e 6/1/2012' ) ;
  insert into "Xs"( "tp","pth","dt","descrip" ) values( 'A','c:\\iqx\\pdfs\\payslip\\payslip2.pdf','2012-1-13','Payslip w/e 13/1/2012' ) ;
  insert into "Xs"( "tp","pth","dt","descrip" ) values( 'C','c:\\temp\\selfbill1.pdf','2012-1-6','Invoice w/e 6/1/2012' ) ;
  insert into "Xs"( "tp","pth","dt","descrip" ) values( 'C','c:\\temp\\selfbill2.pdf','2012-1-13','Invoice w/e 13/1/2012' ) ;
  insert into "Xs"( "tp","pth","dt","descrip" ) values( 'B','c:\\temp\\Payslip 2011-2012 Wk-09 05.06.11 001ICG Davies Ryland Dean.pdf','2012-1-13','Thing with complex file name' ) ;
  select "tp","pth","dt","descrip" from "Xs" where "tp" = "pFileType" order by "tp" asc,"dt" desc
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."NetFileList" IS 
{create PROCEDURE pears."NetFileList"( in pWebUserID char(20),in pFileType char(25) )
result (FileType char(25),FilePath char(250),FileDate date,FileDescription char(100) )
BEGIN
 // Dummy place holder function
 // Live version will use pWebUserID to look up payroll company id and payroll employee code and then call Accord.Accordpayrollruns
 declare local temporary table Xs(
   tp char(25),pth char(250), dt date, descrip char(100)
   ) not transactional;
 insert into Xs (tp,pth,dt,descrip) values('A','c:\\iqx\\pdfs\\payslip\\payslip1.pdf','2012-1-6','Payslip w/e 6/1/2012');
 insert into Xs (tp,pth,dt,descrip) values('A','c:\\iqx\\pdfs\\payslip\\payslip2.pdf','2012-1-13','Payslip w/e 13/1/2012');
 insert into Xs (tp,pth,dt,descrip) values('C','c:\\temp\\selfbill1.pdf','2012-1-6','Invoice w/e 6/1/2012');
 insert into Xs (tp,pth,dt,descrip) values('C','c:\\temp\\selfbill2.pdf','2012-1-13','Invoice w/e 13/1/2012');
 insert into Xs (tp,pth,dt,descrip) values('B','c:\\temp\\Payslip 2011-2012 Wk-09 05.06.11 001ICG Davies Ryland Dean.pdf','2012-1-13','Thing with complex file name');
 select tp,pth,dt,descrip from Xs where tp=pFileType order by tp asc, dt desc;
END
}
</code>