DSXchange

Hi Ray,

plslc000:>echo $TZ
CST6CDT



My source table has a field time_zone contains the value of (E,C,P,M) for Eastern,Central,Pacific and Mountain.Please advice me how to find the UPC offset for the timezones EST,CST,PST,MST.


Thanks,
Satheesh

Hi All,

can anyone share your ideas on how to generate the UTC offset value from the transformation stage.

Standard timezone offset from UTC [-12,14]





Thanks,
Satheesh

Hi All,

We are generating xml files by using xmloutput stage..while creating the default xml header to be

<?xml version="1.0" encoding="UTF-8"?>

is there any way to change the xml header as below..

<?xml version='1.0' encoding='ISO-8859-1' standalone='yes'?>

Hi All,

We have created a huge xml file(8 million recs) by using xmloutput stage.The job aborts in the middle of xml extraction.

Kindly let me know how to split the same into 2 or more xml files.





Raj.

Hi All,


Thanks for your suggestions. I am done with it.


Satheesh

Hi Ernie, Thanks for your inputs. When i tried with XMLOutput stage i got the below value <Outlet Id="10009" Name="SUMMERLIN @ WASHINGTON" Address1="30 N. SUMMERLIN AVE." City="ORLANDO" State="FL" PostalCode="328012930" CountryCode="US...

Hi All, I could see some of my projects contains a palette with least no of stages, where as some other projects having all of them. Eg: Prod1:Palette Database, file,plugin,processing,RealTime,XSatges ect.. where as in Prod2:Palette Database, file,,processing,RealTime How do i add the missing plugin...

Hi, I just want to create an xml file with the help of xml writer from oracleDB as source. Output <Id=1 name="aaa" age=23 city="plano" state="TX" /Id> <Id=2 name="bbb" age=25 city="Divnie" state="OH" /Id> Please through me some light on how...

Hi Ernie, Finally i tried to manage to send the messages to ISS Builder through MQConnector stage. But the thing is ISS is not recognising the input messagesobjects. There were some java version issues(Stage class compiled only in 1.5 version) with that. ISS builder support 1.4.2 version. Thanks, Sa...

Hi,

We have passed the records into it. From the DSLog it open/close the MQ connection and commited the transaction. No error from our side.

But when we check from MQ side no message in the MQ.


Please through some lights on this.


Thanks,
Satheesh

Hi All, We were trying to pass the records from Dataset to the target MQConnector stage through JavaConnector Stage(Java PLUUpdate Object converts datas into binary format) and sends it into MQ. When we run the job the job completed successfully and we even see some records get into MQ through perfo...

Hi All, When we try to insert the records into the DB2 I series tables we got the below error messages: CIP_SKU_Price,0: [IIS-CONN-ODBC-000004] ODBC function "SQLExecute" reported: SQLSTATE = HY000: Native Error Code = -7008: Msg = [IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB D...

Hi Anbu,

I failed to execute your input in my PX job(as the column as described in decimal(11,2).


Thanks,
Satheesh

Hi All, I have an requirement to obtain the pricevalue from Oracle(Decimal 11,2) to create an dataset and this will be the source of MQSeries(JDA is the target system). Eg:Input 00000000049.99 00000000159.90 Eg:Output 49.99 159.90 I just need a output as above,Please let me know your inputs on this....

Hi All, We are having issues for the below job flow. We created a dataset which contains the Store_id,Run_date and P_Id. This needs to be passed to the next sql statement in an iterative way. i.e: we have around 40000 store_id,P_Id. Eg: SELECT 1,2,3,4 from Table WHERE Id in (<Store_id>, <P_ID>) AND ...