file pld

[Former Member]

Thanks,

does pld create a file in any b1's folder to be transported from one PC to another pc? i don't want to use copy express, is there another solution? thanks

[former_member186095 · Accepted solution]

Hello,

There is no file pld in the b1's folder since the pld reports are store in the tables,, i.e rdoc. Your client can access thepld if you give authorization. If you want to move pld from one pc to another pc, it could be meant from one company database to other company database, if it is true, here is the query :

INSERT into [Jakarta].[dbo].[RDOC]

SELECT [JPI_JKT].[dbo].[RDOC].* FROM [JPI_JKT].[dbo].[RDOC]

WHERE [JPI_JKT].[dbo].[RDOC].DocCode = 'IBT30002'

INSERT into [Jakarta].[dbo].[RITM]

SELECT [JPI_JKT].[dbo].[RITM].*

FROM [JPI_JKT].[dbo].[RITM]

WHERE [JPI_JKT].[dbo].[RITM].DocCode = 'IBT30002'

AND [JPI_JKT].[dbo].[RITM].[Doccode]

IN (SELECT Doccode from [Jakarta].[dbo].[RDOC])

Execute it in the SQL query of SQL 2005 enterprise or standard edition.

Rgds,