SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

how to use TPT in DS2 data step?

Accepted Solution Solved
Reply
Regular Contributor
Posts: 223
Accepted Solution

how to use TPT in DS2 data step?

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


Accepted Solutions
Solution
‎08-30-2017 03:11 PM
PROC Star
Posts: 504

Re: how to use TPT in DS2 data step?

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.

View solution in original post


All Replies
PROC Star
Posts: 504

Re: how to use TPT in DS2 data step?

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;

 

Regular Contributor
Posts: 223

Re: how to use TPT in DS2 data step?

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

Solution
‎08-30-2017 03:11 PM
PROC Star
Posts: 504

Re: how to use TPT in DS2 data step?

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.
Regular Contributor
Posts: 223

Re: how to use TPT in DS2 data step?

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

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 230 views
  • 1 like
  • 2 in conversation