DSXchange

Nagraj, You can incorporate 'dsjob' commands with combination of unix commands in your shell which you use to run your datastage job. Steps: Standardize all the link names from where you want to count the no. of records processed. List all your grep you into a file using -lstages using dsjob command...

Can you please disable your smiles?
Try to CAST your field to Number(n) in your SQL and use Integer(n) as your data type.

On CAST the field to Decimal(38,10) in SQL and in transformer take the value just before '.' by using Field function.

Let us know your results please.

By default we don't get '+' signs for any positive calculations as we get '-' sign for negative values.
If your requirement is to have an '+' sign simply concatinate '+' to your calculation result. But, your target data type should be of Varchar/Char type.

sreedharmsc,

You can call the DSJOB commands in your script which actullay runs your datastage job. Take the first and last evenId of the job and then add 1 to get all your job parameters by using the 'lognewest' option with DSJOB.

I guess you can also use "UNIX new line" as a record delimiter on the file format.

Pradeep, As Ray said, we cannot apply any kind of functions on a Null value. As per your code, if a null comes you will be Trimming which will lead you into fatal. In you derivation first check for Null values then do rest of the coding. Also, if you can get rid of redundant brackets, your code will...

I have a field which can have values like '111.00','12','aaa'. This field is defined as varchar field. I have to check if this field is a positive real numbers or not. For values like '111.00','123.56' and '12' - i can convert into decimal values and can use the condition '>0'. So, my concern is if ...

Time to mark this thread as 'Resolved' :D

It is probably trying to find double quote character (34 is the ascii value of "") and it found '1'. Check your data length and the format in the sequential file stage.
Open the file and see what it is exactly at the end of "Account_Number" field..

Thanks ray,

I missed the field markers. I've used Trim with the combination of @FM - It worked.

I have a requirement where, if the 3 field in the Unix file is 0, a notification has to be sent. I used a 'Execute command' activity after my job activity stage. In the execute command stage, i am giving as below- Command : CUT Parameters : -d, -f 3 /file.txt In the triggers section is am giving the...

Hi, Just wanted to know if the 'Link Execution order" option on the transformer executes on the order we give. I have two output links going out from the transformer each to the database. 1st link should delete the records from the database based on the key field. 2nd link will load the data af...

Ok, now here is my code: $DSTAGE_EXE/dsjob -lstages $DS_PROJECT $DS_JOB$INVOCATION_ID | grep 'Src_' > $File SrcCnt=0 TotalCnt=0 for LINE in `cat ${File}` do SrcCnt=`$DSTAGE_EXE/dsjob -stageinfo $DS_PROJECT $DS_JOB$INVOCATION_ID $LINE | grep -v 'Status code = 0' | grep "In Row Number" | cut...

Craig,
I was trying with the following syntax-

dsjob -stageinfo DS_PROJECT DS_JOB$INVOCATION_ID DS_STAGE | grep -v 'Status code = 0' | grep "In Row Number" | cut -f2 -d ":" | awk '{print $1}'` > /dev/null

Craig,
I was trying with the following syntax-

dsjob -stageinfo DS_PROJECT DS_JOB$INVOCATION_ID DS_STAGE | grep -v 'Status code = 0' | grep "In Row Number" | cut -f2 -d ":" | awk '{print $1}'` > /dev/null