DSXchange

Diya,

stage variables might help here. Can you please make your question a little clear.

Greg,

There is some very good information on this if you search for Program Source in the forum.

Check this

viewtopic.php?t=91554&highlight=Program+Source

I think it will throw a warning saying too many columns in record, but yes you read the record.

Is the metadata same on both source and target and what properties did you set in the flat file.

Thanks for the response. Hi deepak/Thumsup9, please suggest me which is the exact format D-DMY or D-MDY and i also checked there are no spaces in the function. i tried for both,but it is not loading any data. please help me . Thanks in advance Vardhan, Whats the format on the database. Can you plea...

It should be D-DMY

I suggest you try and see.

thumsup9 wrote:Try this:

oconv(iconv(Linkname.columnname, "D-MDY[2,2,4]"), "D-YMD[4,2,2]"):"00:00:00"

Sorry, you said the format was DD-MM-YYYY, check this

oconv(iconv(Linkname.columnname, 'D-MDY[2,2,4]'), 'D-YMD[4,2,2]') : ' 00:00:00'

Try this:

oconv(iconv(Linkname.columnname, "D-MDY[2,2,4]"), "D-YMD[4,2,2]"):"00:00:00"

Can you logon to SAP using your ID. It looks like access issue.

You seem to have used Expression Type as Custom - Conditional. Can you please post the Expression you used. Custom trigger expression: - Process_BILLOMAT.$JobStatus = 2 or Process_BILLOMAT.$JobStatus = 1 Thanks, One way to do this is if Process_BILLOMAT.$JobStatus <> DSJS.RUNOK then send this to No...

You seem to have used Expression Type as Custom - Conditional. Can you please post the Expression you used.

Hi all, Is there a simple way to pevent an ftp if the file doesn't contain any records? My job is currently creating a zero length file. I know I could write an after script to do this but just wanted to confirm that was the only way. Check it in unix before you run the job. use If condition like I...

Using an ODBC enterprise stage. Do you have a DSN. Create a DSN first and then use it on your ODBC stage.

You cant use OCONV in Parallel jobs.one way to do this is to do TimestampToString and then StringToTimestamp functions to migrate DB2 timestamp to Oracle Timestamp. StringToTimestamp(TimestampToString(inputdate,%yyyy-%mm-%dd %hh:%nn:%ss),%yyyy-%mm-%dd %hh:%nn:%ss) Check the format of timestamp in Bo...