DSXchange

I have a problem with a Java program,



java -jar CaptureLMPS.jar



and I need to execute it in Datastage, does somebody have an idea on how to do it.



Thanks

I need to converter this sql calculation to Datastage, both dates are timestamp

result = floor (date1 - date2)

I have the following message

Error in output column derivation expression for column result in link DSLink129. Invalid conversion requested from a timestamp to a dfloat.

Thanks
Javier

Field (inputstring,'@',2)

Hi I'm trying to extract part of a string (eg. extract "yahoo.com" from " email@yahoo.com ") using the Left function. eg. Right(myString, Index(myString,"@",1)+1) but don't work Please is there a known issue or am i doing something wrong here? Prompt reply appreciated. ...

and Soundex function ??

index(table.column,'XXX',0) Is this syntax ???

Thanks

Hi All,

I need any functions or suggestions to implement the AlNum and Alpha operator in datastage.

Eg. if Alpha(table.column) = 1 then 0 else 1 or if AlNum(table.column) then 0 else 1

I need return when the column is invalid Alpha and also Alnum.

Any inputs most appreciated.

Regards,
Xavi

Hi All, I need any functions or suggestions to implement the LIKE and SOUNDEX operator in datastage. Eg:- table.column like '%XXXX%' and also the function Eg. Upercase(Soundex(Trim Leading Trailing(table.column))) I am converting some sql scripts to datastage jobs,the issue is I have to implement th...

You have no idea and the pushd/popd mask things. Why not comment out the "@echo off" for now and see what it logs? ... I put the @echo off in comment and it didn't work, I am obtaining this when I run log: The dslog is: Output from command ====> C:\DSProjects\DEVL_DM> (this one is the Dat...

You have no idea and the pushd/popd mask things. Why not comment out the "@echo off" for now and see what it logs? ... I put the @echo off in comment and it didn't work, I am obtaining this when I run log: The dslog is: Output from command ====> C:\DSProjects\DEVL_DM> (this one is the Dat...

lstsaur wrote:Try the following:

Command: START
Parameters: #seq_path# #APORIProcessDeleteFile#

#seq_path# = \\filedev\ETLDataFiles\Devl\DM\XXX\Test1\
#APORIProcessDeleteFile# = deletefile.bat

did nothing, I think the problem is not changing the directory by default DataStage

jguerrero wrote:Hi,

Do you try to use:

Command:#seq_path#\#APORIProcessDeleteFile#
Parameter: (what you need inside the script)

Command: cmd
Parameters: "#seq_path#\#APORIProcessDeleteFile#"

#seq_path# = \\filedev\ETLDataFiles\Devl\DM\XXX\Test1\
#APORIProcessDeleteFile# = deletefile.bat

It looks like both your pushd. and popd are not working. Put a test statement after the cd /D "%workDir%" to make sure your "cd" to that directory is successful. Don't just assume it's in the specified directory. The dslog is: Output from command ====> Microsoft Windows [Version...

I don't think "@" (no echo) will work as the command. With everything parameterized it typically is a "shell" command so perhaps "cmd" would work for Windows there? :? ... I change it to CMD, stays in DataStage directory and does not change the directory LAN Output fro...

Hi I'm using in Execute Command stage to call a DOS batch script that in turn runs .bat, my parameters is: Command: @ Parameters: "#seq_path#\#APORIProcessDeleteFile#" ( \\filedev\ETLDataFiles\Devl\DM\XXX\Test1\deletefile.bat ) But I have trouble because it does not make the call to the sc...