Exporting single spool with R3trans

[dino_dose]

Hello

I need to export few spools to be imported  into another system.

For this goal, I though to export the relevant entries of the following tables: TST01, TST03, TSP01 , TSP02, TSP02L.

For example , in order to get the spool 23435 on the second system , I want to run R3trans with the following control file

export

client =250

file ='spool.export.data'

SELECT * from TST01 WHERE DCLIENT='250' AND DNAME='SPOOL0000023435'

select * from TST03 WHERE DCLIENT='250' AND DNAME='SPOOL0000023435'

select * from TSP01 WHERE RQIDENT = 23435

select * from TSP02L WHERE PJIDENT = 23435

select * from TSP02 WHERE PJIDENT = 23435

The records from the first two tables are exported , but the last three tables aren't, because of a syntax error depending by the fact that the field in the WHERE clause is not CHAR but INT4 Lenght 10.

I don't know the correct syntax to be used in this case: in case I add the quotes, the error is that the field is not a CHAR.

Leaving without clause,

2EETW000 error when reading the R3trans controlfile

2EETW000 syntax error at line 10, symbol "23435".

2EETW000 error when reading the R3trans controlfile

2EETW000 syntax error at line 11, symbol "23435".

2EETW000 error when reading the R3trans controlfile

2EETW000 syntax error at line 12, symbol "23435".

Can anyone help me to correct the syntax of the control file?

Thanks a lot

[crossing_global]

Please, re edit file usin editor plain text. It worked for me.

Example.

Create whit touch: RFC_exp

EXPORT

file = 'QUA_RFC'

delete from RFCATTRIB

select * from RFCATTRIB

R3trans -w RFC_export.log RFC_exp

[divyanshu_srivastava3]

Hi Dino,

Goto SE11 and check for the correct field name and it's data type.

Once checked, update script and re-run r3trans -w to export.

Regards,

[Reagan]

select * from TSP02 WHERE PJIDENT = 23435

The syntax error looks like with PJIDENT = 23435 which I believe should be PJIDENT = '23435'

I doubt whether that will work, long back I tried to export few entries and it never worked.

You can try and let us know.

Good Luck

RB