DATA Step, Macro, Functions and more

Invalid physical name

Reply
Super Contributor
Posts: 625

Invalid physical name

I'm using file writer transformation in my DI job to create the .txt file. After the successful execution of the job, when I tried to open .txt file, I'm getting an error like "Invalid Physical file". Code generated by file writer transformation as follows.

 

data _null_; 
   set &SYSLAST; 
      attrib TBKPAR length = $2; 
      attrib CRI length = $12; 
      attrib P2KBRN length = $2; 
      attrib CRIHIS length = $12; 
      attrib P2KBRH length = $2; 
      attrib SD length = $9; 
      attrib S2KBRN length = $2; 
      attrib XXAROL length = $8; 
      attrib PSI length = $9; 
      attrib HDK length = $3; 
      file "!FSB/common/life_details_crdb_50_tmp_timestamp.txt" lrecl=1226;
      
         put 
             @ 1 TBKPAR  
             @ 3 CRI  
             @ 15 P2KBRN  
             @ 17 CRIHIS  
             @ 29 P2KBRH  
             @ 31 SD  
             @ 40 S2KBRN  
             @ 42 XXAROL  
             @ 50 PSI  
             @ 59 HDK  
         ;
   
run;

Properties of File wrtier transformation:

 

FW.pngFW2.png

 

Appreciate if someone of you help me understand the likely cause for this issue.

Super User
Posts: 5,849

Re: Invalid physical name

How do you try to open it?
Almost any text file generated can be opened using standard text editing tools.
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 91 views
  • 1 like
  • 2 in conversation