DSXchange

Thanks For the reply ArndW

Yes

Hello every one!!.

how can i use 'IN' function in datastage transformer.
Advance Thanks.

do you need exact 30 days old date or every last month date..?

Yes what you said is exactly correct. when it moves it should move with the file name.

output got: Text_0-0-0

expected : Text_04172013

echo %DATE:/=% set /a d= %DATE:~0,2% set /a month=%d% set /a d= %DATE:~5,4% set /a year=%d% set /a d=%DATE:~3,2% set /a yesterday=%d% - 1 MovE "\\C\DS\DS_TEMP\BOB\TEXT_.csv" "\\C\DS\DS_TEMP\BOB\TEXT_%month%-%yesterday%-%year%.csv" This is the syntax I am using which works fine wh...

Probably a relative v. full path issue but as noted we'd need to see your syntax to have any idea what is going on. Thank you for your reply, right now I dont have syntax, but it is nor marl syntax to get the yesterday date. I will post the systax ASAP. I am sorry for this... my question is do I ne...

Thank you for your reply, i used after job subroutine execDos and the input value is input file. Thats all i used, bash file is executing perfectly but the expected output is wrong. When I ran the same commands in Cmd prompt, it is executing perfectly, but when the same executed through datastage it...

Hello All, I need your suggestion here. i am trying to trigger the MS-DOS Batch file. Here it moves the file and add the date for the file name, when i tried this directly it is working but when i used this command through datastage, it is not working. expected result : User_Log_Test_Mon 04-15-2013 ...

You are right ... btw what version you are using?

getsatish_gk : use field option for '|' in transformer, then use Pivot stage to convert into rows

try this;
DecimalToDecimal(mylink.mydec,"trunc_zero")

or

DecimalToDecimal(mylink.mydec,"round_inf")

keep the target decimal length of 10 and a scale of 2.

as per your validation, use index function to search for the string what you want, like HTTP or HTTPs.
and later search for the string in which format you are expecting it to be.
Check for conditions for your URL contains alpha numeric.

Thank you Ray for the information.

I am curious about this topic.
Can you please brief in detail where to check this detail job logs, i mean for audit purpose, such as how many rows it passed, inserted or rejected etc.,
can you let me know where did you use this DS_JOBOBJECTS table?

change the data type for all fields to timestamp & check with 'isvalid' condition for 'timestamp', then you can write if then else condition

thx