GeekInterview.com
Series: Subject: Topic:
Question: 547 of 633

What about System variables?

Asked by: Interview Candidate | Asked on: Aug 4th, 2005
Showing Answers 1 - 3 of 3 Answers
pavan

Answered On : 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. 

Yes  1 User has rated as useful.
  
Login to rate this answer.

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

  
Login to rate this answer.
rameshkm

Answered On : Apr 15th, 2009

View all answers by rameshkm

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

  
Login to rate this answer.

Give your answer:

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

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.