pavan

• Aug 4th, 2005

 

DataStage provides a set of variables containing useful system information that you can access from a transform or routine. System variables are read-only. 
 
@DATE The internal date when the program started. See the Date function. 
 
@DAY The day of the month extracted from the value in @DATE. 
 
@FALSE The compiler replaces the value with 0. 
 
@FM A field mark, Char(254).  
 
@IM An item mark, Char(255). 
 
@INROWNUM Input row counter. For use in constrains and derivations in Transformer stages. 
 
@OUTROWNUM Output row counter (per link). For use in derivations in Transformer stages. 
 
@LOGNAME The user login name.  
 
@MONTH The current extracted from the value in @DATE. 
 
@NULL The null value.  
 
@NULL.STR The internal representation of the null value, Char(128).  
 
@PATH The pathname of the current DataStage project. 
 
@SCHEMA The schema name of the current DataStage project. 
 
@SM A subvalue mark (a delimiter used in UniVerse files), Char(252).  
 
@SYSTEM.RETURN.CODE  
Status codes returned by system processes or commands.  
 
@TIME The internal time when the program started. See the Time function. 
 
@TM A text mark (a delimiter used in UniVerse files), Char(251). 
 
@TRUE The compiler replaces the value with 1. 
 
@USERNO The user number.  
 
@VM A value mark (a delimiter used in UniVerse files), Char(253). 
 
@WHO The name of the current DataStage project directory.  
 
@YEAR The current year extracted from @DATE. 
 
REJECTED Can be used in the constraint expression of a Transformer stage of an output link. REJECTED is initially TRUE, but is set to FALSE whenever an output link is successfully written. 

raviatpals

 Profile Answers by raviatpals Questions by raviatpals

• Mar 15th, 2006

 

If a new system variable is added in Windows, how can we access it in datastage?

Thanks in advance

rameshkm

 Profile Answers by rameshkm 

• Apr 15th, 2009

 

The variables which used in through out the system not in singale project is called System variables .some of the system variables are  @FALSE,@PARTITIONNUM ,@NUMPARTITIONS,@TRUE, which are avaialable in Transformer

sangam

• May 23rd, 2018

 

Out of all those , i am not able to find/call them in a transformer , like @LOGNAME , while i use this in a stage variable, it throws error , saying its not defined. I am using Datastage 11.5 version. Any idea how to get this done ?
Thanks !