DSXchange

Hi Another strange problem. Our unix script issues the dsjob command to reset a job. dsjob run -mode RESET -wait <proj> <jobname> After issuing the command, The script hangs. Once this happens, all subsequent unix scripts submitted also start hanging after issuing the reset command. The jobs can be ...

Thanks. Eventually we may have to implement it that way for just this one supplier. Currently, we load hundreds of flat files from different providers and the way we have designed the system, we have a generic load job that uses schema files to do the load. For each new supplier we just create a new...

Hi We need to load a supplier provided file which is supposed to be fixed length but the last field, which is numeric, is not being padded by space to make it fixed length. It is variable length as shown below aaaaBBBBBccccc 9<LF> xxxxBBBBBccccc 43<LF> We are using the following schema file to load ...

Hi

This started happening to me recently.

When i check the /tmp, the file that it is complaining it can't open is very much there.

Then i rerun the job and it succeeds.

So why this error ?

Hi I am just wondering if it is possible to install Datastage runtime separately from the rest of the server. This is my scenario. Currently i have Datastage installed on an AIX machine. I have my unix scripts (ksh) in a folder on this same machine. When the unix script is invoked it does whatever i...

Eric - I am a little confused on the subject. Actually i implemented the UTF-8 to UTF-16 job after reading this article below that says - "UTF-16 encoding uses fixed 2-byte character codes to represent characters." Here is the link to the article - https://datastagetips.wordpress.com/2011/...

Still don't know what property to use in the schema file, but i found a workaround. Apparently, even though i am using a schema file to define the file metadata, i can still go into the sequential file stage, go to OPTIONS and set STRIP BOM=TRUE. At run time, any property that is defined both in the...

UTF8 file can be converted to UTF16LE file by reading the entire line in the UTF8 file as one field and then outputting as UTF16LE. Then use the schema file for UTF16LE as below // Fixed width file record {record_delim='\n',final_delim=none,delim=none,quote=none,charset='UTF-16LE'} ( ServiceName:UST...

Hi I need to know the property one would use in a schema file to set STRIP BOM = true. I need to do this because the BOM character is ending up in the data and also causing characters to shift 1 position to the right when reading a fixed length file. I have already tried stripbom=true and strip_bom=...

Hi guys We are currently running Datastage 8.1 on AIX. Next year we are planning to upgrade to 11.3 on Linux. The plan is to export the jobs from 8.1, import into 11.3, recompile and do regression as well as parallel testing. I know we are covering a lot of years and it potentially could be quite pa...

Change

athos.techsol.com
to just
athos

This kind of a fix worked for us.

When we put servername.ascap.com in the APT file wwe start getting this error.

If we change it to just the "servername" the error goes away.

Source for date data is oracle table ...traget database is netezza table. issue is with the ORCHESTRATE.FILE_ID_IN when i hard code the value for FILE_ID_IN in the query then job ran fine UPDATE XTABLE SET ORIGINAL_LOAD_DT = ORCHESTRATE.RUNDATE WHERE FILE_ID in ('asdf','zxcv') please advise how to r...

Hi, I have issue with odbc stage upating the netezza table. Query: UPDATE XTABLE SET ORIGINAL_LOAD_DT = ORCHESTRATE.RUNDATE WHERE FILE_ID in ORCHESTRATE.FILE_ID_IN Passing below values to the odbc stage RUNDATE = '9999-01-01' FILE_ID_IN = ('asdf','zxcv') issue is with the ORCHESTRATE.FILE_ID_IN when...

Hi, I have issue with odbc stage upating the table. i have below 2 columns coiming into odbc stage COLUMN NAME SQL LENGTH NULLABLE RUNDATE Date 10 yes CLM_FILE_ID_IN Varchar 255 yes there is only one row coming into odbc stage and value for these columns are RUNDATE = Date CLM_FILE_ID_IN = ('2014040...

hey ...thanks for the solution. That worked for me too. Can anybody shine a light on why though ? Most of the file work with final_delim=end ....what does it do when you specify "none" ? Also, why is the documentation on schema file formats so sparse ? The help and guide in datastage does ...