how to use TPT in DS2 data step?

[Jade_SAS]

Hi All,

    I got an error when using TPT in DS2 data step, the coding and error are below:

proc ds2;

data TD.TEST(TPT=YES FASTLOAD=YES TPT_MAX_SESSIONS=4);

method run();

set test.data1;

end;

enddata;

run;

ERROR: Compilation error.

ERROR: Syntax error or access violation TPT

ERROR: Unable to execute CREATE TABLE statement for table TD.TEST.

    I checked the same DS2 step works without TPT, see coding below:

proc ds2;

data TD.TEST1;

method run();

set test.data1;

end;

enddata;

run;

     What's the correct syntax to apply TPT is DS2 step? Thank you!

Jade

[kiranv_]

this is very interesting. I have not used  proc DS2. can you do try tpt in libname statemnt as something shown below.

libname tera teradata user=testuser pw=testpw TPT=YES;

[Jade_SAS]

Thank you for the suggestion! Tried to add TPT in the libname statement, then try the coding again, unfortunately still get the same error

[kiranv_ · Accepted solution]

looks like TPT is not compatible with proc ds2. Some one from SAS could tell us more about this . I think you can try just fastload = yes dataset option.

[Jade_SAS]

Right, I feel the TPT is not compatible with PROC DS2.