DSXchange

This depends on couple of factors. When ever you want to view a particular record from Table it's so easy to view data but it's so difficult from datasets when no.of records grows. When you want to move staging data from one box to another; if you're using Tables it's easy to move; Since datasets co...

If you're running on UNIX (Solaris) this command should work
dsjob -run -jobstatus <your project Name> <Job Name>

Same business logic can be achieved by creating a server job also. Same hash file is used for Reference and Output.


Input ---- Transformaer ---- Hash File
|
|
Hash File

I will be getting 4 bytes of data thats for sure. Now what should I do

Then you can make data type as Integer on both sides.

Create an environment variables and assign the values over there.

In your job add those environment variables as parameters and set default value to $PROJDEF.

Now, in your Sybase IQ stage variable should look likes #$DBNAME#

Okay you are trying to assign double to int. double can store upto 8 bytes int can store upto 4 bytes. Suppose your input has 6 bytes. Can you store that value into a int type variable ? In your case either you need to chnage int to double or double to int , depend on your requirement. Otherwise use...

1. Can you specify the data types of input and output of 'SNo' field.
2. What's derivation you used in Modify stage ?

DS Admin can unlock jobs using following commands. #cd $DSHOME #/app/ascential/Ascential/DataStage/DSEngine>bin/uv >LIST.READU this will display all the locks, check for that particular job and clear the lock as follows >UNLOCK USER <USER_NO> ALL e.g Device.... Inode.... Netnode Userno Lmode Pid Log...

if you're using WINDOWS O/S sendmail.exe should be available in your datastage server. Please check that sendmail.exe is installed then try to use following commad from command prompt and verify that you receive emails .

sendmail.exe -f %from% -t %to% -s "%subject%" -b %file% -m %server%

mailx should work for this case.
example :

echo "This is a testing msg." | mailx -s "Subject Line" abc@xyz.com

Did you tried with SetNull() in your source fields for blankcolumns instead of '' (single quote, single quote)?

Did you tried with SetNull() in your source fields for blankcolumns instead of '' (single quote, single quote)?

My Requirement was convert EST to GMT. This is a sample code used for particular task. Input Date : YYYYMMDD Time : HH:MI:SS (24 hour clock) Zone : EST output : Corresponding GMT value YYYY-MM-DD HH:MI:SS * This routine will convert given date/time according to the given time zone * Output will be c...

I had the same issue and I wrote a routine and called this rouitine within a Basic Transformer.

I had the same issue and I wrote a routine and called this rouitine within a Basic Transformer.