What about System variables?

Showing Answers 1 - 3 of 3 Answers

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. 

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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account


 
Send   Reset

 

Related Answered Questions

 

Related Open Questions