DSXchange

I may have mis-spoke. I was looking in the Parallel Job manual. I'm not sure if a Server function exists.

The example looks like an Epoch "(00:00:00 UTC, January 1, 1970), measured in seconds", which is a time_t value.

Look at the function "TimestampFromTimet". Once you've the DS timestamp you may apply any of the Date/Time function.

I've a row that contains a id column, storehours and a series of open/close times for each day of the week: ID StoreHours OpenMon CloseMon OpenTue CloseTue OpenWed CloseWed ... 1 NEED_TEXT 09:00 21:00 09:00 21:00 09:00 21:00 2 NEED_TEXT ... Passing this row into a External Filter I need to change NE...

Try adding an alias to the decode(Col4,null,'A','B'). Select Col1, Col2, col3, decode(Col4,null,'A','B') Col4 from Table1; Using sqlplus to verify the name of the last column. Without the alias it'll be something like DECODE(... 1* select sysdate, decode( 1, 'A', 1, 'B', 2, 'C', 3, 4) from dual SQL>...

What about using a Copy Stage to send the data to the Sequential File and to the next Transform Stage?

The method I used to get a sequence file name that includes the current date: In the Parallel Job add a Parameter for the Current Date. In the Sequential File stage include the parameter in the File: myfile_#Current_Date#.txt Create a Sequence Job. Add UserVariables Activity Stage. In the UserVariab...

Hello All, Using DataStage 8x, I'm creating a job that extracts image information from an Oracle database and creates a XML file. Part of the information is a URL to the image location. When executed the Job needs to determine if image caching is enabled and the base part of URL. Example: If caching...

Hi,
I am using FTP stage to FTP a sequential file from server1 to server2. After ftp is complete I want to rename the file at server2.
Is there any way or stage in which I could rename the file?
Regards.

[quote="pranay"]Not very sure about this one, but try changing the link order. It might work out fine. Let us know if this works fine.

had tried changing the links still no effect.

Hi, I am using ODBC Connector stage to insert records into dB2 files. I am getting following error. "ODBC_Connector_7,0: [IIS-CONN-ODBC-000016] Execute failed on statement INSERT INTO schhabra.tststr(STRNUM,STRNAM) VALUES(?,?)" This error looks like I am trying to insert Null (?) value to ...

When I am trying to connect my db2 files using ODBC connector stage its working fine. I am able to read my file. But the issue is when I am trying to use DB2_UDB_ENTERPRISE as a stage I am getting error

Hi Istsaur,
May I know what are the required entries for DB2 in my PATH AND LD_LIBRARAY_PATH.

Following error are captured in Directors Event Detail FATAL: main_program: PATH search failure: FATAL: main_program: Could not locate operator definition, wrapper, or Unix command for "db2read"; please check that all needed libraries are preloaded, and check the PATH for the wrappers WARN...

After installation of Datastage we are for the first time trying to connect dB2 files. So we might be missing some of the setup. Do we need to do some setup on iSeries (AS/400) Box too? following are the settings as copied from Director Event Detail LD_LIBRARY_PATH=/app/DataStage/InformationServer/S...

It says "Path Search Failure" But in my environment variables under General category my path variables are already set LD_LIBRARY_PATH = /usr/lib:. PATH = /usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:. I am new to Datastage enviornment. Could you please help me out and let...