DSXchange

Hi, I am trying to produce reports on job statuses on our various project and was wondering how I can also get the invocation id in the report. I run the following as a test: dsjob.exe -domain NJROS1A2495:9080 -user ##### -password ###### -server NJROS1A2495 -ljobs -status 3/2/96/97 EDW I do get a l...

I receive the following from the command line:


D:\JohnP>SH
$ iconv -f iso-8859-15 -t utf-8 00201720100318011426.xml
iconv: Invalid codeset: utf-8: The system cannot find the file specified.
iconv: Invalid codeset: iso-8859-15: The system cannot find the file specified.

The developers have not tried that as they are waiting for me to guide them. If the project is defaulted to another Character-set could we still use the Iconv with the ISO8895-15 character set?
Would you happen to know if this can be used when the input is an XML file?
Thanks - - John

Hi, I was hoping someone roaming this forum may give me some direction on this. We are running DatasStage 9.1.2 on Windows with NLS enabled. When I check the installed Charactersets in NLS in the Administrator Client I see the Characterset ISO8859-15 as installed. When I run the command iconv -l it ...

Perfect..This solution works perfectly!

Thank You All!!

Thank You everyone for your suggestions! When using the "Generate Multiple file" option using a key do you know the default directory where the output files get written too?

Hi, We have a simple Job that has a DB2 connector as the source data going into a LookUp stage and the reference data into the LookUp is another DB2 connector. The link name from the reference DB2 connector to the Lookup Stage is named "inCurrentAPP". In the monitor when I look at this lin...

Thanks Craig!! I tested it out and it does behave the way IBM described.

I opened a Ticket with IBM and here is the response I received...not what I expected: "Good morning John, I pinged one of our DB2 Connector engineers to answer your question: When one batch has duplicate keys there are two scenarios: 1) If the table does not have the key the update will fail fo...

Hi, We have a few different theories on how the following would process and wanted to hear from folks on this forum: We have a DB2 connector with a commitcount of 5000 that is running in Update then Insert mode. If we have two records with the same key in the same batch of 5000 records will the seco...

Looks like the DBA's were right....They proved it tom showing that when the proc is called directly a new transaction id is issued with every commit but when called from DataStage it is the same transaction id for the entire 34 billion row delete. I engaged IB engineering and they were aware of this...

Hi, We have a simple job that calls a stored procedure on SQL Server that deletes around 34 billion rows in chunks (Commits on the DB every few 100, 000 deletes or so). We tested the job today and received the following from the production DBA: "We are stuck, The Datastage processing is done as...

Hi, We are migrating our final DataStage project from 8.0.1 to version 9.1.2 and are having an issue with NLS. We never installed NLS on the 8.0.1 instance and jobs are all running fine there for the past three years. I just migrated the dev project and since NLS was installed on our 9.1.2 environme...

I enabled "bulk load" in the SQL SERVER ODBC driver definition and my question is what stage are you using that is enabiling you to bulk load into SQL server. Is there a check box?

Thank You!!