Can i create & read data from Table at PI 731 Java only stack

[Former Member]

Hello ,

I have a requirement to rename file with sequence number before sending this to FTP server . I had taken a look at several options like calling  RFC & passig to  UDF to alter the file name as one of option . I would like to even explore option that can we create a table at PI 31 Java only and read and then increment the sequnece . Please advice .

[gagandeep_batra]

Hi Sitaraman,

i think you can use file construction mode as Add Counter as below:

Regards

Gagandeep

[naveen_chichili]

Hi,

I suggest you to store the data in a temporary DB table and autoincrement there and fetch using JDBC Lookup and then send the file to the target server.

Regards,

Naveen.

[Former Member]

"I suggest you to store the data in a temporary DB table and autoincrement there and fetch using JDBC Lookup and then send the file to the target server."

So are you suggesting to create this table at DB associated to Java layer ? If so how can i create this Table ? Do we have to take PI Admin help to create this and store some number? Please clarify .

[Former Member]

Gagandeep -  Will this not get reset when you restart the server ?

[naveen_chichili]

No i am asking you to configure one channel to PI DB where you can store the data and increment....

then you can fetch the data from the DB table using JDBC lookup.

Regards,

Naveen