DSXchange

Hi,

I am migrating my project from DataStage 8.7 to DataStage 9.0. Is there a way to migrate the Users even.

Thank you in Advance.

Hi, I have found the issue, when I am running the sequence from DataStage Scheduler, it is taking user : nt authority\system Which is a bug in DataStage 8.7 (please refrer to the link below) and IBM has a patch for it. http://www-01.ibm.com/support/docview.wss?crawler=1&uid=swg1JR44777 When I am...

Thank you for reply. I tried to specify UserID and Password in DataSatge Adminstrator, same as link mentioned below: http://www.dsxchange.com/viewtopic.php?t=94842 Now my process is not kicked off at scheduled time. I tried to schedule multiple times to test, it was not kicked off once even. My wind...

Hi, I am trying to schedule a sequence in DataSatge Scheduler. My sequence FTP files from source location, when I was scheduling it was running all good except FTP part as the id I was using to schedule doesn't have permission to connect to FTP server. My question is which userid/password scheduler ...

Thank you for reply. I am not updating same table I am selecting from. Only I am doing update Then insert in target and i am using Odbc connector stage for that.Source and targets are different.I tried to run with 1 node, still no luck. Even I tried update<table_name> with nolock in update query. I ...

Hi, I am trying to upsert a SQLserver table,job design is like SQL Server Enterprise--> CPY --> SQL Server Enterprise Process is failing with Error : ODBC_Connector_51,0: ODBC function "SQLParamData" reported: SQLSTATE = 40001: Native Error Code = 1,205: Msg = [Microsoft][SQL Server Native...

Hi, Finally Execute Command Activity is working : I am calling powershell like : powershell.exe <Script_name with Path> I need to change window setting Set -ExecutionPolicy RemoteSigned Below link was helpful : http://social.technet.microsoft.com/Forums/en-US/winserverpowershell/thread/d49939e9-0690...

Thank you for reply. I agree when I am trying to run with ./ it might fail , but in last option i tried to run only the script name with path : C:\test\dummy.ps1 Then I tried to execute like C:\test\dummy.ps1 in Execute command Activity stage, it doen't fail or complete , it keeps on running , eveni...

Hi, Sorry for posting in wrong place. Thank you for your reply. I am trying as below : Created a dummy job only with Execute command Activity stage and wrote echo dummy in Command , this running good and finished successfully, echo dummy in log. Now I saved same text (echo dummy) in a file name dumm...

yes, it is to pass input column to output , as you see in previous response:

You can create a field in the XML Input stage for it and leave the Description / XPath Expression blank which tells the stage to just pass it through

Hi, I am able to get file name in ES stage , but actually I am unable to parse it through XML input stage. In XML input stage's output , I have created a field FILE_NAME (same as Input column name) , it doesn't have any derivation (1st field) then I have all XML fileds (created by XSD). It is able t...

Hi, My requirement is to call a poweshell script in DataStage Sequencer. I searched and followed same as mention to call script: http://www.dsxchange.com/viewtopic.php?t=146877 My script is to rename files, when I run the script in powershell, it works fine but as when I am trying to run in Execute ...

Thank for reply. I tried to remove all other XML fields just keeping File_name filed from input to output of XML Input Stage. Job is failing with below error The link contains no derivation rules But Immediate after ESS from Transformer I have added a Peek , it shows filename corrcetly. Thank You

Hi, Thank you for response. We do get File_name with path ESS stage, so used count to find 1st \ and get only file name. My design ESS --> Transformer --> XML Input stage--> Peek ESS: reading file using specific programme (ls -l) Transformer : 2 fields , 1 input file_name(getting from ESS) and 2nd g...

Thank you for response , I changed datatype of target table from Integer to Float and it is working.

Thank you.